I have created a prompt report in Cognos which is a line chart that pulls values for a building that will run each day. I have scheduled this report to run and save as a pdf file to a folder on the server. This all works fine but I want to run this report for each building (the parameter) in the query item...there are about 10 in my current database. I can create 10 different reports...one for each building and schedule them to run 1 minute apart. This works fine...but ideally, I want to create one report and have it run for each building in turn from the prompt list dynamically. This would avoid having to create a new report every time a building is added plus I would only have one place to go if the report needed a change to be made vice 10 different reports. Can anyone tell me how I can dynamically feed all the parameters to one prompt report so that all 10 pdf files are created from one scheduled report?
We are using Cognos 8.4...installed on a Windows 2003 server environment. The reports are created against a SQL Server database using stored procedures as the query subject.