How to insert a grand total at the bottom of a Master/Detail report


When you have created a Master Detail report, any calculations that you inserted into the report are broken up into individual sections. You can insert a grand total at the bottom of the report by taking the following steps;

  1. Scroll down to the bottom of the report so that you can see the last section .

  2. Click on any blank area of the report and you will see the Section Lines appear.

  3. Holding down the <Ctrl> key, click on the cell containing the word 'Sum' and on the cell containing the section total. These should both be highlighted.

  4. Click on Edit at the top of the page and choose Copy.

  5. Right click with the mouse on the blank area below the last Section Line and choose Paste. Your grand total will now appear at the bottom of your report.
 UQ Reportal
  Log On
  Register 
  About the Reportal 
MIS Home MIS Home
Resource centre Resource centre
Contact us Contact us
Site map Site map