Page Break or Page Set is used
to break the report output into several pages based on the unique column value.
Page Break is simple which can be applied only on one column whereas, Page Set
is more advanced in which we can break the data based on multiple columns.
Steps to create
Page Break
1. Create a simple list report with the following columns
2. Select Country
column > select Structure menu and
click on Page Break
3. Run the report and you will see the data distributed
across several pages for each Country.
Steps to create Page Set
1. Create a List report with
the columns as shown below
2. Go to the Report pages
--> drag and drop Page Set as shown below
3. Move Page 1 to the Detail
Pages
4. Select Page Set1 and assign
it to Query1
5. Click on Grouping &
Sorting --> drag and drop Current Year and Product Line columns as shown
below
6. Run the report and see the
difference in the way the output gets generated per page.
4 comments:
Instead of using PageSet in Cognos drop a block in to the section and change the size of the object to expand the page 8 or 11 inches. You can also change size of your footer. It out performs the pageset feature.
Hi Pat, Thank You for your comments! I agree that creating a section can display data in separate blocks for each unique value however, it is not recommended if you want to display data in separate pages automatically. PageSet option is exclusively used to display data in separate pages based on the unique column value.
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC)
, kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC). We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com
Good post! Thanks for sharing this information. I appreciate it. It is very beneficial for visitors.
trade show booth maufacturers
Post a Comment