I need to automate the running of many reports on a nightly basis. These reports all use parameters and most use stored procedures. The database is MS SQL Server 2000.
Is there any facility in CR, CE, or CA that will allow me to schedule reports in this manner?
Often the same report will be executed multiple times using different parameters for each run and then be distributed to a specific user for whom those parameters are designed.
Currently, we have a Lotus Notes application that calls the report object, passes in the appropriate parameters, and names the saved output file. I have seen various books on CR that have a cd with a VB program included to accomplish this type of "batch" processing.
Any input will be greatly appreciated.
Is there any facility in CR, CE, or CA that will allow me to schedule reports in this manner?
Often the same report will be executed multiple times using different parameters for each run and then be distributed to a specific user for whom those parameters are designed.
Currently, we have a Lotus Notes application that calls the report object, passes in the appropriate parameters, and names the saved output file. I have seen various books on CR that have a cd with a VB program included to accomplish this type of "batch" processing.
Any input will be greatly appreciated.