Defining page set
In a grouped report, it might be sensible to start a new group at a new page. In this recipe, we will see how to achieve it for the Product line grouping.
Getting ready
We will use the report generated in the previous recipe for this.
How to do it...
Open the report in Report Studio and go to Page Explorer.
From Insertable Objects, drag a new Page Set.
Move the existing report page under this new Page Set (within Detail Pages).
Now select the Page Set and from its Properties, set the Query to the one being used from report list (that is, Query1)
Open the Grouping & Sorting dialog and drag Product line under Groups.
Now run the report to test it.
How it works...
When we create Page Set, Cognos generates the report output as a bunch of pages rather than one continuous report. The pages are driven by the query and grouping that we defined in the Page Set properties.
Here, it will create a new page for every Product line. Hence, a new group will start from a new page. This applies...
