Bursting a report with multiple queries

[naghamaj]

Hello,

I am trying to burst a report consituted of multiple queries , is their any way of doing that?

Thank you for your help

[BigChris]

The number of queries shouldn't make any difference - it's the report that gets burst

[naghamaj]

Yes but the burst is based on a single query , how can I make all the report affected by the burst?

[MFGF]

Yes but the burst is based on a single query , how can I make all the report affected by the burst?

Generally you'd include the report objects that use the multiple queries in a list, and use master/detail relationships between the list query and the multiple report object queries. Then you'd burst the report on the list query.

Cheers!

MF.

[TheFrenchGuy]

Hi there

You have to link master query list with your crosstabs thanks to "master detail relationships" in properties.
Then in burst options (File tab) you link the master query to your recipient item

Attachment detail :
1)   The prompt page retrieves selected parameters
2)   And filter the master query list
3)   All the queries inside the list are linked with the master query list parameters and then are filtered too
4)   Finally, the burst option, link the master query list with the burst query in order to send the good report to the good person via email addresses

Hope it'll be helpfull