COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Aravinth on 03 Nov 2007 07:14:33 AM

Title: Probelm with grouping in page set
Post by: Aravinth on 03 Nov 2007 07:14:33 AM
Hi,

I have a report which has a detailed list and 3 levels of cross tab summary.

1st (Lowest level) - Country
2nd                    - Region
3rd(Highest level)  -Over all summery

I need a page break at each level.

There is one master detail relation ship Query 1 (Master) --> Query3(detail).

I have created a page set and added two levels of grouping
1st (lowest) - country (Query3)
2nd            - Region    (Query 3)

When i generate the report "Region" summary cross tab is not appearing in the report. Can anyone help me out with this?

 
Title: Re: Probelm with grouping in page set
Post by: rockytopmark on 03 Nov 2007 07:25:11 AM
Could you include an attachment of your report spec?
Title: Re: Probelm with grouping in page set
Post by: Aravinth on 04 Nov 2007 10:22:17 PM
Hi,

I foud the bug. Page set was poiniting to a wrong query.

Thanks everyone for your help.