Bursting Reports from Multiple Queries

[wyconian]

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

[Rahul Ganguli]

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

[CognosPaul]

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.

[wyconian]

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.

[Rahul Ganguli]

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

[wyconian]

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.