preview

Report Studio Multiple Headers

Good Essays

Tip or Technique

Multiple Aligned Column Headers in Lists and Crosstabs
Product(s): IBM Cognos 8
Area of Interest: Report Design

Multiple Aligned Column Headers in Lists and Crosstabs

2

Copyright
Copyright © 2008 Cognos ULC (formerly Cognos Incorporated). Cognos ULC is an IBM Company. While every attempt has been made to ensure that the information in this document is accurate and complete, some typographical errors or technical inaccuracies may exist. Cognos does not accept responsibility for any kind of loss resulting from the use of information contained in this document. This document shows the publication date. The information contained in this document is subject to change without notice.
Any improvements or …show more content…

The issue with list reports is that the existing column titles does not allow for additional rows to be added.
The techniques described below will allow a report author to add header items such as “Product Per Unit” and “Product Sales” to list reports as in the following: IBM Cognos Proprietary Information

Multiple Aligned Column Headers in Lists and Crosstabs
A similar technique will be presented for crosstabs to incorporate elements into the crosstab structure such as “Order Method Quantity” and “Product
Sales” as in the crosstab image below:

3 Layout and Design
3.1

List Report
Open Report Studio using the ‘GO Sales and Retailers’ sample package and create a new list report.
Drag in right: •









the following columns into the list in the order below from left to
[gosales_goretailers].[Products].[Product line]
[gosales_goretailers].[Products].[Product type]
[gosales_goretailers].[Products].[Product name]
[gosales_goretailers].[Orders].[Unit cost]
[gosales_goretailers].[Orders].[Unit price]
[gosales_goretailers].[Orders].[Unit sale price]
[gosales_goretailers].[Orders].[Quantity]
[gosales_goretailers].[Orders].[Revenue]
[gosales_goretailers].[Orders].[Gross profit]

Group the [Product line] and [Product type] columns.

Click on the ‘List Headers & Footers’ icon
‘List page header’.

IBM Cognos Proprietary Information

in the

Get Access