Hello friends,
I've build a report that compares this week debts status with previous week debts status.
I want to give my users 3 option - 1. see last week changes (as described), 2. see changes over two weeks. 3. see changes over a month
I cannot do it all in one report without having to duplicate my queries
So I can make a parameter "NumberOfDaysParam" that my query will use when running
How do I schedule this one report so it saves 3 different results (reports) by changing the parameter, so that my users can instantly access the snapshot without having to run the report with different parameter value?
Thank you
Michael
It's not quite clear from your post, but I'm assuming that your parameter "NumberOfDaysParam" is working to your satisfaction.
There are two ways that I know about of satisfying your requirement.
1. Start with the New Job Wizard (click on the New Job icon), and on the second screen, add your report three times. Then, click on the pencil under Options and prompt values, and set the Prompt Values for each occurrence.
2. First create three Report Views of your report, preferably giving them names which indicate the time period covered. Then modify each, by specifying the Prompt Values. Next, proceed as above, adding each view once instead of adding the report three times.
In both cases, under Select Default Options, you can specify Report Options, such as Save as PDF / Excel / whatever
Also, in both cases, the New Job dialogue will lead to the Select an action - job screen, where you probably want to choose Save and Schedule. Create a schedule with the frequency that suits you.
I gather that you would like the results for the three versions to be instantly available within Cognos Connection, so in fact my option 1 above is not suitable. You need three objects within Cognos Connection so that your users are able to go directly to the pre-run output. (Option 1 would be viable if you were bursting or emailing the output to recipients)/
So try my option 2, and post back if you have problems :)
EDIT: Just realised that you posted this in the Active Reports board, whereas my advice is based on working with "classic reports" :-\
If you are working with Active Reports, then I'm not sure how applicable my reply is to your requirement...
Hi Michael,
Yes, the 3 ReportViews do the trick!
Each View runs with its own parameter and saves the output separately from the others!
Problem solved!
Thank you very much!
Michael