Creating multiple reports for each prompt value

[aravindk]

Hello,

I have a report which prompts to select from a list of Sales Rep names. Is there any way I can generate multiple reports for each of the the prompt values? Like if I have 200 sales reps, I want the reports to be run with 200 different values and saved into a folder. Is this possible in impromptu?

 

[DoubleD]

You can write a Cognos script to accomplish this.
First run a report that gives you a list of reps, create that as a recordset.
Now for each record in that recordset, run the report and save it using the reps name as the file name.

Pain is stress leaving the body.

DoubleD

 

[aravindk]

Oops, I forgot to mention that I want this to be done in IWR. Will any kind of scripting be done in IWR?

 

[DoubleD]

You could still script this process, or I believe there are XML commands to automate IWR processes.
Your other option is to Create a UserClass for each Rep, then use IWR Bursting to accompish this.

Why not let them run their own report? This would save a large amount of processing time as well as save space so that unnecessary reports are not created.


Pain is stress leaving the body.

DoubleD

 

[aravindk]

In this case, sales rep themselves dont have access to reports yet. We have over 1000 sales reps divided into 15 territories, approximately 100 sales rep per territory. We have monthly reports that are being emailed to these sales reps by the territory representative. These representatives need an easier way instead of running the reports 100 times with with different paramaters.

I will continue to explore the script option;

 

[b1ffa]

We use cognos script editor to run all our reports. Most of the reports are published in pdf format. As an earlier reply suggested you could use a recordset to generate the prompts, or you could hold this data as a csv file and load it into an array. The array data would then be merged into the statement running the impromptu report. Using cognos script editor you should also be able to pick up the pdf files and send them via email