Hello,
I have a report with three lists as follows:
list1 uses query1 and displays detail rows with no summary row.
list2 uses query2 and displays details and summary for related data.
list3 uses query3 and displays overall summary row only
There is a master/detail relationship between list1 and list2 which works fine. The report has a section break for Year.
The end user would like to have list3 display only at the end of the report. List3 only displays the summary row as planned. But it's appearing at the end of each Year section break instead. Is there a way to fix this so list3 only appears at the end of the report instead of at the end of each section break?
Cognos 10.2
Thank you!
Are the list all on one page? Could you put List3 on a seperate page?
Yes, they are all on one page. Ideally, the summary list would appear at the bottom of the others instead of a separate page.
Would it be possible to use a Conditional Block, then drop the summary list into the Conditional Block? I'm not sure how to create the condition or variable though--something like, if this is the last page (max?), show the list.
A conditional block would be possible, but it might be unnecessarily complicated for your requirements.
How about this:
- drag in a 2 x 2 table
- move List1 & List2 into the two cells in the first row
- (optional: merge the cells in the second row, and centre the alignment)
- drag List3 into the second row
You'll probably need to adjust the rows per page property (or whatever it's called, I don't have Cognos in front of me) in the different lists, in order to get it to present nicely.
Thanks Michael. I tried that but no luck. I think part of the problem is the report contains a Page Set so that each Year section break starts on a new page. If I remove the Page Set, I get the results I was looking for with my original layout--except for the page breaks of course--which the user requires.