Support Article
Generated Excel File doesn't display "Grand Total"
SA-3504
Summary
A Report Definition which uses Summary Functions have a Totals Row at the bottom of the Report which is called the "Grand Total". When exporting to PDF this row is displayed, but if we export it to Excel, it does not display the Grand Total row.
Error Messages
No errors, just the Grand Total row is missing in the Excel file.
Steps to Reproduce
1. Create a Report Definition with summary functions
2. Run the report and verify whether the "Grand Total" is displayed at the bottom of the report.
3. Export to Excel, open in Excel and see.
Root Cause
The customer expectes the grand total value to be displayed on excel sheet,when clicking on export to excel button.
Resolution
This is the expected behaviour because the Export to excel feature provided by PRPC is to provide a manipulatable spreadsheet and its not the replica of the report generated on the report browser.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.