Report Studio Multiple Headers

Only available on StudyMode
  • Topic: IBM, List, Cognos
  • Pages : 8 (1318 words )
  • Download(s) : 62
  • Published : November 10, 2012
Open Document
Text Preview
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 changes to the information contained in this document will be documented in subsequent editions. This document contains proprietary information of Cognos. All rights are reserved. No part of this document may be copied, photocopied, reproduced, stored in a retrieval system, transmitted in any form or by any means, or translated into another language without the prior written consent of Cognos. Cognos and the Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated) in the United States and/or other countries. IBM and the IBM logo are trademarks of International Business Machines Corporation in the United States, or other countries, or both. All other names are trademarks or registered trademarks of their respective companies. Information about Cognos products can be found at www.cognos.com

This document is maintained by the Best Practices, Product and Technology team. You can send comments, suggestions, and additions to
cscogpp@ca.ibm.com .

IBM Cognos Proprietary Information

Multiple Aligned Column Headers in Lists and Crosstabs

3

Contents
1

INTRODUCTION ............................................................................................ 4

1.1
1.2
1.3

PURPOSE ............................................................................................................4 APPLICABILITY .....................................................................................................4 EXCLUSIONS AND EXCEPTIONS ..................................................................................4

2

REPORT REQUIREMENTS.............................................................................. 4

3

LAYOUT AND DESIGN ................................................................................... 5

3.1
3.2

LIST REPORT .......................................................................................................5 CROSS TAB REPORT ...............................................................................................8

IBM Cognos Proprietary Information

Multiple Aligned Column Headers in Lists and Crosstabs

4

1 Introduction
1.1

Purpose
This document will show step-by-step how to create list and crosstab reports in Report Studio that contain multiple aligned header rows to ‘group’ column information together and display additional information about the items displayed in the report.

1.2

Applicability
The following examples were built using IBM Cognos 8.1 MR2 Report Studio against the GO Sales and Retailers package. The list report technique can be applied to Report Studio reports created in ReportNet as well as in IBM Cognos 8. The crosstab technique has been available since the introduction of the ‘Crosstab Space (with Text)’ insertable toolbox object in IBM Cognos 8 MR1.

1.3

Exclusions and Exceptions
These techniques should work with Relational, Dimensionally Modeled Relational (DMR), and OLAP data sources. However, they have not been explicitly tested in these scenarios.

2 Report Requirements
Often the metadata available from a data source does not provide some of the grouping information necessary for quick evaluation by consumers. While the information can be added to a report,...
tracking img