Hey everyone
I always have issues with bursting, guess it's just one of those things I find difficult to do :-(
I have a report with 2 pages. Each page comes from a different set of queries. I need to be able to burst the report to a list of email recipients. The recipients can have either or both of the pages. The email addresses for each page come from 2 different queries.
Question is how to set up bursting to email addresses from different queries to send pages based on different queries? I've tried adding a union query to get all the email addresses in one query but I get an error message saying the burst query can't be a nested query.
Frankly I'm out of ideas, can anyone help?
Thanks everyone
Hi,
I tried bursting using a union query, and it is working fine.
Can you look again and see if you missed something.
Regards,
Rahul
You could do it the lazy way - make a page set based on that query, and use a master detail relationship on all your data containers.
Thanks for the replies :-)
I think the issue is the query that identifies the burst recipients is a union query because the emailaddresses come from different places.
I'm still getting the following error, any ideas?
RSV-VAL-0016 The burst query Query1 cannot be a nested query.
Hi,
This error is because you are using teh query for any nexted data container.
Please refer the link below.
http://www-01.ibm.com/support/docview.wss?uid=swg21342478
Regards,
Rahul
Thanks for that. I think I figured it out. It seems the issue was I had added a pageset on pages I was trying to burst. When I took out the pageset it worked OK.
Thanks everyone for your help.