Skip to Content
0

Exporting the same yearly client report for 2000 clients. Possible without parameter prompt?

Nov 27, 2017 at 03:09 PM

19

avatar image
Former Member

I have the same crystal report I want to run for all of my clients. At the moment i have a parameter box set up to ask which client to run it on and it does.

If i purchase a crystal server license, is there a way to tell it to run ALL clients instead of choosing which ones. Then get it to export all 2000 client reports to a shared drive, and name it by the client name. I watched the tutorial and I know it can export them to a shared drive and name it with the client name easily. I just don't know the one critical part ...

Can you tell it to run each client instead of prompting with a parameter box?

Would like to schedule it to run this daily or monthly and load them to our website. Just didn't know how to get it to run all of them instead of picking and choosing to run it 2,000 separate times.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Nov 28, 2017 at 09:07 AM
0

Hi Jeven,

You should be able to create a 'Publication' to burst reports to each client.

I'm not very sure if it works with a prompt, though. You may have to remove the prompt and map a 'dynamic recipient' report to the 'client' field.

Here's how to do this with WebI, however, the process is similar for a CR too:

https://wiki.scn.sap.com/wiki/display/BOBJ/Personalization+in+SAP+Business+Intelligence+4.0+Web+Intelligence+Publications

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded