IBM Cognos 10 Report Studio Cookbook - Second Edition

List report or crosstab report

This recipe shows that most of the time 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 recipe.

How to do it...

In this recipe we will start by creating a list report, and then we will create a crosstab report to see the difference:

1. Create a new list type of report based on this package.
2. Drag columns onto the list report 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 ...