COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Anna711 on 14 Nov 2013 01:25:30 AM

Title: Multipage report using one query and different parameters
Post by: Anna711 on 14 Nov 2013 01:25:30 AM
Hello,

I have a report that has 9 pages without prompts (since the report is meant to be sent by email). Each page includes a list report and all pages are identical. The only difference is that each list displays data for a different parameter value, for example language:
Sheet no. 1 - Data for English language
Sheet no. 2 - Data for German
etc..


I don't want to create 9 queries. Is there a way to pass a parameter based on page no. or something like that?

Thank you!
Title: Re: Multipage report using one query and different parameters
Post by: technomorph on 22 Nov 2013 10:09:29 PM
Group by filtered language column on list, then add pagebreak.