IBM Cognos 10 Report Studio Cookbook - Second Edition

Using conditional blocks – many reports in one

The purpose of this recipe is to introduce you to a very useful and powerful control of Report Studio called conditional blocks.

Users want a report on sales figures. They want the facility to split the numbers by product lines, periods, or retailer region, any one at a time. For convenience purposes, they don't want three different reports, instead they are looking for one report with the facility to choose between the report types.

Getting ready

Create a report with three list objects. Define the list columns as follows:

• List 1: Products / Product line and Sales fact / Quantity
• List 2: Time / Year, Time / Month, and Sales fact / Quantity
• List 3: Retailers / Region and Sales fact / Quantity

Define appropriate ...