TL4: Develop a New Custom SSRS Report
GOAL: Develop a new report showing all purchase orders that are invoiced in the given period. Parameters for the report should be the From and To date, and there is also a flag that represents whether only the big orders (> 100K) should be considered for the report.
- TASK #1: Create a report menu item and a dummy RDP data provider with no X++ logic. Create a real report data contract class because of the report parameters. Create an SSRS Report with one design (e.g. AutoDesign) and add it to AOT.
- TASK #2: Register this dummy SSRS report as a Docentric report.
- TASK #3: Create a custom Docentric DSP (Data Source Provider) class (DTNewCustomSSRSReportDSP) and implement the generateXmlDataSource() method. You can use this VS DSP class template. Remove all other methods except the description() method.
- TASK #4: Generate the DDSP file by opening the report menu item and selecting the Generate DS print destination. Design the template, assign the template to the report in Docentric report setup, and run the report from D365FO.