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

Adding page breaks to a report

Started by RickHenderson, 21 Feb 2017 10:02:07 AM

Previous topic - Next topic

RickHenderson

Nice work so far. I'm new to reporting in Cognos 10 and only had a bit of experience modifying reports in Cognos 7. How about a list of recommended tutorials or training sites?

I've been creating list reports up until now, and need to create a report with 1 record per page, but a single student record would have multiple class records on the same page, so setting the # of Rows per page in a list isn't helping.
--
Institutional Analyst and Tech Trainer

BigChris

Have you tried using a page set?

Lynn

Quote from: RickHenderson on 21 Feb 2017 10:02:07 AM
Nice work so far. I'm new to reporting in Cognos 10 and only had a bit of experience modifying reports in Cognos 7. How about a list of recommended tutorials or training sites?

I've been creating list reports up until now, and need to create a report with 1 record per page, but a single student record would have multiple class records on the same page, so setting the # of Rows per page in a list isn't helping.

The training programs through IBM accredited partners are a good option if you can manage it.

You should post your reporting question in the appropriate reporting board to get the most responses.

Another option besides page sets is to use a master-detail relationship:

Create a query that returns the student information and then associate that query to the page (not a specific layout container on the page). This will let you place the student information anywhere you like on the page (e.g., using tables to organize). Presumably there will be a student ID of some sort included in this.

Then drag in a layout container, such as a list, that is associated with a different query which returns the class information (plus the student ID). Use a master-detail relationship on student ID which will filter the list to show classes for the student on that specific page.

The detail query will be fired separately for each and every student (page) so there are performance implications if your volumes are massive.


RickHenderson

Thanks everyone. It was working with Page Sets, I was just thrown off by how it moves the last page to the top so the pages have to be re-ordered.

A co-worker of mine has taken the full Cognos 10 basic and advanced training, so now I have access to the manuals. One of them is from Avnet. The manuals are quite good but it doesn't take long to run into situations that are more complex then the given examples :)
--
Institutional Analyst and Tech Trainer