Report Studio Multiple Headers

1304 Words6 Pages
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
Open Document