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?
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.
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.
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.