-
Book Overview & Buying
-
Table Of Contents
IBM Cognos 8 Report Studio Cookbook
By :
Users want to see the details of Orders. They would like to see the Order number and the details (product name, promotion, quantity, and unit sell price).
Create a simple list report with Sales order | Order number, Product | Product name, Sales fact | Quantity, and Sales fact | Unit sale price as columns.


The information we are trying to show in this report can also be achieved by normally grouping on order number. That will bring all the related records together. We can also set appropriate group/level span and sorting for better appearance.
However, in this recipe, I want to introduce another feature of Report Studio called Section.
When you create a section on a column, Report Studio automatically does the following:
Some of the advantages of creating sections are as follows:
If you create a section for a crosstab or chart report, you need to explicitly define the master-detail relationship. Chapter 2 defines the master-detail relationship.
Change the font size
Change margin width
Change background colour