Conditional block: 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 block.

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: Product | Product lines and Sales fact | Quantity.
  • List 2: Time dimension | Current year, Time dimension | Current month and Sales fact | Quantity.
  • List 3: Retailer site | Region and ...

Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.