If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Burst Report - Two Lists

Started by damienm, 19 May 2008 01:56:05 AM

Previous topic - Next topic

damienm

Hi I have got a burst report which consists of two list reports, see attached. My problem is that when I burst the report based on brand the detail list 1 report works fine however list 2 gives me all the detail at store group level. I only want to see the store group summary based on the brand burst key, I am completely lost in how to solve the problem, any ideas?

angela

I haven't looked at your attachment but we were recently trying to burst a report that had two pages and the second page had different grouping than the first.  Bursting behaved very oddly and support said it was because of the second page.  You may have to break the second page into its own report so Bursting will work as expected.

rockytopmark

Put both pages (you said you have 2 reports, but I think you meant pages) into a single Page Set.  This way, you can set the burst up by the Page Set query with the Burst query. 

My guess is your two lists are driven from different queries and that is the problem, which adding the page set in will alleviate.

damienm

Thanks everyone, solved the problem by creating an additional master detail relationship on list 2 rather than having list 2 based on list 1 query.