If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to cause a page break?

Started by JoelR, 24 Jan 2008 10:17:07 AM

Previous topic - Next topic

JoelR

How do you make a report so that a grouped list of results do not wrap on to another page.  Rather, if the data in a report is coming to the end of a report and there is not enough room for all of the data to be displayed then a page break is automatically initiated and a new page is used as a starting point for the new group of data?

Suraj

This document describes how you can set page breaks on a grouping level.
Description:
How to set page breaks on a grouping level in Cognos 8.

Solution:
Use the Page Sets feature in Cognos 8 Report Studio. This has changed from the procedure used in Cognos ReportNet.
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=127309

JoelR

I went through a lot to get this:

Description:

How to set page breaks on a grouping level in Cognos 8.

Solution:

Use the Page Sets feature in Cognos 8 Report Studio. This has changed from the procedure used in Cognos ReportNet.

Steps:

As documented in Chapter 3 of the Cognos Report Studio User Guide:

Create page sets to associate pages with a query structure to force page breaks. For example, a query contains the data item Product line, which is grouped. Creating a page set that is associated with this query adds page breaks for each product line.

1. Pause the pointer over the page explorer button and click Report Pages.

2. Create the pages you want to appear in the report.

3. In the Insertable Objects pane, drag the Page Set object to the Report Pages pane.

4. In the Properties pane, click the Query property and click the query you want to associate to the page set.

5. Organize the pages in the report by dragging report pages to the page set you want.

6. Insert the page containing details in the Detail Pages folder. Detail pages are the pages that repeat based on the items you group by in the following step.

Tip: You can insert multiple detail pages into the same page set, and link them using a master-detail relationship.

7. Define the grouping structure for the page set:

Click the page set.
In the Properties pane, double-click the Grouping & Sorting property.
In the Data Items pane, drag the data item you want to group by to the Groups folder in the Groups pane.
Click OK.

8. Repeat steps 2 to 6 to create other page sets.

Tip: You can nest page sets, and join them by defining a master-detail relationship. Create nested page sets to have pages occur within other pages. For example, you want pages containing product type information occur within pages containing product line information.

Note: Grouping an item for a page set is not the same as grouping a column in the layout.

Grouping a column in the layout visually shows groups in a report. Grouping an item for a page set groups the item in the query. If you want to use an item that is already grouped in the layout, you must still perform step 7.