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