Hello,
We are having issues with the new DDSP file we uploaded where our developer added 2 new fields to the purchase order confirmation (PurchPurchaseOrder.Report). When we look at the template designer we see the data and live preview look accurate, but when we run the report in D365 a lot of the values are blank. I think all values besides the company data are blank. Any ideas?
Template and preview
Purchase order confirmation in D365 - values are blank besides company data
Hi Karin,
The first thing to check is the DSP class selected in the Docentric AX Report table:
Do you have the DSP class that your developer has customized selected here?
That worked, thank you! It was set on the defualt DSP.
Hi @Karin. I have correct DSP class selected still having same issue.could you please suggest another solution. On local live preview, it shows data. but when prints on the actual live system, values don’t show up.
Hi @Subodh_Kant ,
First you need to make sure that the same DSP class has been used for generating the DDSP file when you created the template and for executing the report. Some fields may be omitted during runtime but present during design time due to missing values coming from the standard SSRS pipeline.
When you generate the DDSP file along with the executed report, you can check whether the data is present in the data-source. If the field values are empty or 0 this means that they came that way from the SSRS pipeline which in turn means that you need to either fill them in or in some cases find setup that is responsible for filling in the values (one example is printing totals for Purchase Order which is controlled by a flag on the Vendor Purchase order defaults).
Try printing SSRS report and compare the report output. If the data is not there when you print the SSRS report then you need to figure out how to get the data to show in standard. If the data is there when printed with SSRS, print the same report using Docentric and generate the DDSP, then search for these values inside the data-source. If the values are present in the data-source, then the bindings on the template level are incorrect. If the values are not present let me know and we can troubleshoot further.
Hi @SemirT, thanks for the quick reply. When I printed the DDSP file, The data is present there. When I preview the word template locally with DDSP. It shows the field value, but when I click print in d365 the update field values don’t appear.
Hi @Subodh_Kant,
Could you send us the template, generate the DDSP file for the report that is coming out empty, and send a screenshot of the empty report to our support email?
Also, please enable “Discover report technical name” so we can see which report is being executed, and include a screenshot of the Docentric setup for this report.
@AmirO I have sent the DDSP file and template in the chat to you.
