COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Kcog123 on 30 Apr 2014 09:23:39 AM

Title: Limit number of pages/repeater table objects in PDF output-Report studio
Post by: Kcog123 on 30 Apr 2014 09:23:39 AM
Hi,
I have a repeater table that displays output for each month.(for all 12 months as a month adds up)
Eg: 
April
March
February
January

Now i want to limit the output to display only last two months.
Eg:
April
March

I changed repeated table properties-General-Down from 12 to 2.
It worked. But the rest of the months (February and January) are displayed in second page in PDF.
I don't want them at all.
So how to exclude the second page from output? or is there any other solution?

Thank you...
Title: Re: Limit number of pages/repeater table objects in PDF output-Report studio
Post by: Lynn on 30 Apr 2014 10:13:33 AM
Take a look at point 1 c in this post:

http://www.cognoise.com/index.php/topic,24030.0.html
Title: Re: Limit number of pages/repeater table objects in PDF output-Report studio
Post by: Kcog123 on 30 Apr 2014 10:20:21 AM
Lynn,
It's relational package and it's very simple report, using repeater table.
Please let me know if you need any other info.
Title: Limit number of pages/repeater table objects in PDF output-Report studio
Post by: Lynn on 30 Apr 2014 10:40:02 AM
Add a filter to your query so that the other months are not returned in the result set


Sent from my iPhone using Tapatalk