Finance | Project Operations, Human Resources, ...

how to populate the fields from class Data Provider

(0) Share

Report

Posted on by Community Member

how we can populate the fields from Class DP and Class Controller to get the fields displayed on report .I need to display Sales Order Customer report through this.

Kindly help me anyone.

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

Are you saying thatr you have no idea how RDP classes work and you're looking for an introduction, or do you have any particular problem?

In short, you write records to a table (usually a temporary one) in processReport() (or a method called from processReport()) and return a reference to this table buffer in a method decorated with SRSReportDataSetAttribute. Check out How to: Use a Report Data Provider Class in a Report, for instance. You can also look into any existing RDP class to see it in practice.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

What about methods which populate the data in Class DP and .what code to write in controller.

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

I'm sorry, but it's not clear to me what you want to say by your first sentence.

Code "to populate the fields from class Data Provider" is in the data provider class, not in a controller.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In Class Controller, which code we have to write then for sales order purchase my project.

Was this reply helpful? Yes No
huijij 19,811 on at

Like (0)

Report

Hi Jasir,

The method processReport() is used to populate the data.

The SSRS reporting framework uses this class to modify the report dialogs,calling the SQL Server reporting services,

as well preprocessing parameters for the report.

Please check the following link to learn more about creating SSRS RDP report:

http://msdynamics.nevoitech.com/microsoft/create-ssrs-report-in-d365fo/

Hope it help you.

regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

for Salesorder Confirmation ,where can we popluate the fields which does not exists in the temp table.Even if there is requirement of contract class here or not?

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

If you want extra fields, extend the temporary table and add them. Then extend the data provider class and populate their values.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin,

I added a new field to the temp table, added code in report data provider class to populate the new field, all seems to work fine.

But when I tried to add that new field from temp table to the report, it is complaining that temp table doesn't have that new field.

Am I missing some steps to have the temp table refreshed? So that the report can see the new field?

thank you for your help!

Helen

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

Try restoring the data source of in the report definition.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Martin,

I did a recompile of the model, restarted the SSRS reporting services, and I can see the new table that I added to the Data provider class. Next time I will try using restoring the data source.

Was this reply helpful? Yes No