COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chris2001dc on 23 Mar 2009 12:27:24 PM

Title: Bursting with pagination
Post by: chris2001dc on 23 Mar 2009 12:27:24 PM
Hi,

I am working with Cognos 8.3, I need to send a report by email so I use bursting, but this report has to be paginated, the pages are generated depending of an attribute that is not in the bursting table. I can only stablish one relationship master detail in a report page. Anyone has an idea of how can I solve this, please Help.

Thank you

Title: Re: Bursting with pagination
Post by: rockytopmark on 24 Mar 2009 05:16:57 PM
Use Page Sets.... this will allow a 2nd element of your report to have a master/detail and the primary intent of PageSet implementation is for pagination.

You will need to base your Burst relationship on the PageSet query however, so you will need to alter your existing relationship... just FYI

Burst Query
----PageSet Query
--------Report Query
Title: Re: Bursting with pagination
Post by: chris2001dc on 25 Mar 2009 08:20:47 AM
Thanks