APOS Bursting Manager

[senglish]

We have recently purchased APOS and I have set up the Access Bursting database with the details of who needs to receive the slices and the appropriate selection formula.

Much of this information is in the employee database that I am running the report against. I would like to link some tables with these data (employee table etc) and then run a query against one or more linked tables as they contain most of the data I require (name, email, department) and from that I can create the SelFormula field in the query. This would eliminate the maintenance in the Bursting database.

However, it does not seem to want to connect to the database.

Should I be able to do this or is it a no go area?
Thanks for any help
Stephen

 

[MJRBIM]

I don't have that tool, but I think it can be done....

APOS support should be able to help you.

What you are asking for is MULTI-PASS bursting.

1st Pass - get the e-mail info.

2nd Pass - Send the e-mail/report for each address.



Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services