I am trying to schedule 10 reports that go to the same table and ask for the same columns, except that they differ in a key value (i.e. the report selects column a, b, c from table A but differ in the where clause = 'CLIENT1', = 'CLIENT2', etc).
I was wondering if I can use the same report and set an external variable before running it that defines that where clause. All of this scheduled so that I don't have to set the variable manually.
So what I want is for the report to run itself 10 times using 10 different external variables that define the key value of the client.
If such a thing is possible I would gladly take some help.
Thanks!
2 - Options.
Your Scenario. Its sounds like you want to pre-run the report by several different Clients.
Options - Not in any order
Bursting allows you to pre-run and/or pre-deliver a report based on a burst key(Your client id). The report is ran for the entire data set and then spliced by the burst key. You can store these as report output versions and/or target them to be emailed to specific users etc... (This was a popular feature in Cognos created several years back and plenty of documentation on it in the manuals). These reports can be scheduled and pre-ran so you dont' have to wait for Database queries etc...
Report views - You can create a report view on top of report that is nothing more than a logical not physical instance of the report with its own default parameters etc.. This way you can create one report and create as many views on top of it as necessary with differing parameters. These can also be scheduled and pre-ran.
Hope this helps.