Generated Excel File doesn't display "Grand Total"
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.
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.
The customer expectes the grand total value to be displayed on excel sheet,when clicking on export to excel button.
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.