Hello,
In a report created with Electronic reporting, a formula is included in an Excel template.
The value (concatenation of four fields) is displayed in the report.
However, if the Convert to PDF function is checked, the value is not displayed in the PDF file.
Would it be possible to use a formula with the Convert to PDF function?
Thanks and regards
Hello Ludwig,
Thank you very much for your answer.
Best regards,
Quesform
Hello Rahul,
Thanks for the reply.
Best regards,
Quesform
Hello quesform,
What you describe is right.
The reason for that is that the formula is applied if you open and edit the Excel file.
Because the PDF conversion is not doing that you will see blank results.
You have two options to fix that:
1. Adjust your model and do the calculation in ER
2. Create an Excel document, define a sharepoint document library as the output destination and use Flow to convert the excel into a pdf.
Best regards,
Ludwig
I refer here https://dynamicsax-fico.com/tag/electronic-reporting/, may be helpful to you
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156