Running a Cognos Report in a Script?

[adam_mc]

We have a large, complex, multiple step query report that was designed to accept a single Store as a parameter.
I am now challenged with running this same report for all stores.
Due to the design of the existing report, it will not deliver the expected results simply by excepting multiple stores.
(There are multiple Except queries that don't function with multiple stores).

Is there a way to run the existing report in some sort of script loop that will pass the report one store, run report, then pass the next store and so on?

Any thoughts will be greatly appreciated!!
Thanks in advance,
Adam.

[RKMI]

Hi Adam,

Are talking about "Store" as datastore/datasource? (or) An actual store like store 1- walmart, store 2 - bestbuy and ... If the later then you just need to change the prompt out.

Exampale: [xyz].[xyz].[store]=?store? ( The "=" is selecting one store change that to "in" along with the prompt on your prompt page to except multiple values). After which you set you a pagebreak(pageset) to run one store at a time the same query... If you don't include the page break the query will consolidate your results.

If you unable to create something revert back (or) search for pageset/pagebreak discussion there are many examples of this.

By changing that it should run the way you want it too.

Thanks,
RK