Symptom
Report is not producing the same result as it is in ORD when exporting it to excel file.
Environment
- Online Report Designer
- Microsoft Excel
Reproducing the Issue
- Go to Analytics and preview the report
- Set the runtime filters
- Click on "Done"
4. Export the file to Excel using the green icon at the left-hand corner
5. Wait for the report to be on green light in Report Distributor Downloads
6. Once the report is ready, download the report
7. Open the report
Cause
Exporting the file to Excel using the green icon means exporting the report offline. Thus, the runtime filters that was set up before previewing the file online was not being taken into consideration. Only the filters inside the query (Manage filters) is being respected causing the output in online preview mode and excel file to be inconsistent.
Resolution
Instead of exporting the file using the green icon (which is offline), we should export the file using the options available at the right-hand side of the page if we want the runtime filters to be respected by the report as well.
Keywords
- inconsistent records
- data discrepancy
- incorrect values