Burst Multiple Levels

[jshamm]

I have a report that I need to burst on two different levels and not sure how to implement that.  Basically, we have vice presidents who oversee certain stores and I have a report that summarizes their totals on a consolidated page but also detail summaries for each store.  Each store needs to be a separate page so the format would look similar to this:

Page 1 - VP summary (consolidation of all stores for VP)
Page 2 - Store 1
Page 3 - Store 2
Page 4 - Store 3
...

There are approximately 10 VP's and each needs to be distributed their own summary plus collection of stores.  How would I go about bursting this out?

Thanks for any insight.

[cognostechie]

You can create a Master query and associate all other queries as detail queries with a master-detail relationship. In the Burst option, specify the master query, that way it will burst all queries on all pages. I am assuming you do have a key which would associate the stores to the VP . If not, you will have to create a column where you specify who is the VP of each store.