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 grouping, sorting, and aggregation for all the list objects. Make sure that all objects use different queries as shown in the following screenshot:
How to do it...
Conditional blocks are very powerful tool that you can make your report very...
