Question
Report Definition - Exporting Issue
Good morning,
I'm having an issue with the export functionality in Pega version 7.1.6.
I'm looking to export a report definition rule which has properties included which use reference data to display a value rather than the hard coded value from the database.
When I run the report, the values shown are the correct values (reference data values) but when I export to excel it no longer uses the reference data but instead uses the hard coded values from the database.
I've included a screen shot showing a list view rule which allows a user to specify an export format. For example ReferenceData is an export format.
Is there any possible way to specify whether or not a column in a report definition rule should use the reference data values rather than the hard coded values?
Thanks, Lee
I guess you are talking about formatting the column values .
Can you let me know how you are defining the formatting ?
You can refer this video to understand how this can be done , https://pdn.pega.com/pegatube/support-guide-resolving-incorrect-date-format-after-export-excel-report-definition