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.
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 ...