IBM Cognos 8 Report Studio Cookbook

List report or crosstab report

This recipe shows that most of the times it is possible to use a crosstab report instead of a list report, and then discusses the pros and cons of each.

Getting ready

We will use the "GO Data Warehouse (analysis)" package for this.

How to do it...

1. Create a new List type of report based on this package.
2. Drag columns on the list shown as follows. Create grouping and sorting for Product line and Product.
   
3. Run the report to test it.
4. Now save this report and create a new report of 'Crosstab' type.
5. Drag items on the crosstab shown as follows. Define sorting on Product line and Product.
6. Run the report to test it.

How it works...

You ...