Cognos Page Breaks-How to force break the page in List report

List Reports in cognos have default page layouts where there are no breaks in between and they are shown as a straight list. For example in the following picture the list report which spreads across two columns Product line and product name is spread across entire pdf page for all the data items which are stitched together.

Now, if we want a report in which the data is broken into several pages for each individual data item then we need to force the page to break. Suppose, in this case i want the data for product line to be broken for each and every equipment, then you need to give the page break on data item.

Below is the step by step tutorial on how to create a page break:

Create a list report with 2 columns as below. If you would like to check how to create a list report you can go to my previous tutorial on list report creation.

Now after creating a list report, you can go to the insertable object pane 3rd icon as shown and select page from the options available. you can also go here by clicking on the list report and navigating from the list report properties on the left bottom corner and selecting the page level properties.

Now drag and drop the page set as seen in the pic.

In the page set properties, you can select Query value as the query of the list report. In this case, it is query1.

Drag the page1 from above the page set to into the page set. It can be seen in the below pics.

Now in the properties pane, select the grouping and sorting option and select the data item on which the page break or split is to be done.

Now if you test run the report you will see the report as shown. But here the report is not properly ordered.

So we add a sort filter on the data item that is grouped to make the order is either ascending or descending. Here the data item we are trying to break is on product line.

Now save the report and you are done with the list report page breaks.

Where the previous report is just like this.

If you like my tutorials and want more you can always subscribe to this site by clicking on the blue button for subscribers.

~Urs Krish