COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: psandhya408 on 11 Apr 2013 11:56:03 AM

Title: Page break
Post by: psandhya408 on 11 Apr 2013 11:56:03 AM
i have four queries in my report . Now i want a data item that should be page breaked.
Can i associate multiple queries in page set.
Title: Re: Page break
Post by: RKMI on 11 Apr 2013 01:03:07 PM
Hi,

Can you expand more on what you are trying to ask? Yes, you can nest multiple page sets and to different queries but, they need some common elements to associate the master-detail relationship.

Thanks,
RK
Title: Re: Page break
Post by: psandhya408 on 11 Apr 2013 05:14:16 PM

i have a report like this

Department ID:

Query1: No-of students enrolled in course at certain ages

Age5,age10

Query2: No-of students enrolled in other course at certain ages

Age5,age10

Each page should display one departmentt ID and the other two queries.
How can we do that using page break
Title: Re: Page break
Post by: RKMI on 12 Apr 2013 10:21:41 AM
Hi,

It looks like you are trying to do two different page breaks (page sets) and not nest page breaks so you first use the query1 as driver for the first page break and the query 2 with second page break, you might need to do a master detail if you are passing different querys in the page to link with Dept.

Hope this makes sense.

Thanks,
RK