Page Breaks Based on Groups and/or Sections

[cdallum]

Where and what are the settings to set page breaks on a column group or a section?  I have a list report with a group for which I'd like to begin a new page for each new value in the group.  This is an easy matter in Query Studio, but I've been unable to determine how to do it in Report Studio.  I've checked the Report Studio user guide, but it has provided no real value.

[larsonr]

There are a few ways to go about this.

One --> Build a repeater table that pages it out for you based on the group names. You will need to set the repeater table to repeat one down and one wide as well as define your master detail relationship between the list and your repeater.

Two --> Assign the groupings and query to the page so the report knows to page out by each group type (you will need to then create a master detail link between the list and the report page).


These are the few ways that I have achieved this in the past with relatively decent performance.

[Suraj]

In C8, go to page explorer->report pages, drag and drop page set and then drag current page below the page set under detail pages.
Select page set, then click on Grouping and Sorting under properties.
Select the query item you want to set page break on and drag under grouping-->overall.
That will break page for that query item.

[manishtirpude]

hi,
attaching a document will guide u in doing page breaks in reports based on groups/sections.I designed this for you.Please reply if it helps you.
regards,

[swordfish]

Hi,

On the same note .....

Is there a workaround solution for setting pagebreak for excel. In our org, all reports are by default output into excel format. Our users do not want page break output as different sheet (tab) in excel.

We have cognos 8.2 on sun solaris.

Regards
sf

[cdallum]

Thankx for all of the ideas!  This is quite helpful.