Hello,
I am trying to burst a report consituted of multiple queries , is their any way of doing that?
Thank you for your help
The number of queries shouldn't make any difference - it's the report that gets burst
Yes but the burst is based on a single query , how can I make all the report affected by the burst?
Quote from: naghamaj on 23 Mar 2015 07:06:51 AM
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.
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