The Cognos Report Toolkit - Group column headers for list report

Check list of all posts

General note about The Cognos Report Toolkit

Report specification:  Relational, DMR, and Cube

Requirement

Group Sales region and country to region, and group product line and product type as Product.

Layout

1. Create normal list as below, sorted by region, retailer country, product line and product type
   
   

   1. Click anywhere in list and then click create header, then click create overall header

   
   
   
   

   2. Click new header, then click insert newly row above

   
   
   
   

   3. Highlight both newly added rows, then class them as List column title cell

   
   
   

   4. Highlight second added rows, click , then

   
   
   

   5. Remove Overall, and merge the first two column, and third and fourth column, then add text as below

   
   
   
   

   6. Drag the title from first row to third row
   7. Hide the original heading for list

   
   

   Query

   All three queries for relation, DMR are very similar.