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.
Have you tried using a page set?
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.
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 :)