Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

Cognos 8 Report Studio -- How to get the overall totals only on the last page of a Cognos 8 report

Create two pages and set a page break on summary totals.

Steps:

  1) Create a page set
  2) Drag page1 under the detail pages
  3) Select the measures and total them
  4) Delete the summary line so that only the total of the product line is seen
  5) Click on the page set and from the properties click on Grouping and Sorting
  6) Drag the product line to the Groups
  7) Add a new page to the page set
  8) Go to the page and from the data items tab, right click on the query and insert
  9) Ensure that the order in the list is the same as on page 1
 10) Total the measures
 11) Select everything in the list except the summary row
 12) In the properties, click on box type and set it to none
 13) When the report is run the summary should be shown on the last page

To see hidden objects in the page, click on visual aids next to the run and lock button and select 'show hidden objects'