Can a Snapshot report be created programmatically?

Can I create a Snapshot report with parameters programmatically in RS 2000 or RS 2005? If this can be done what is the command for it? Thanks.

Yes. The report has to be set to Snapshot Execution and has to have default values. The SOAP method to call is UpdateSnapshot.

If you want to create a history snapshot then you can call CreateReportHistorySnapshot.

You can not set the parameters when calling these parameters. If you want the parameters different then you must first set the report parameters then call one of the above methods.

-Daniel

|||

Hi Daniel,

Thanks for the tip... you put me in the right direction. Now, how do I change the parameters before getting a Snapshot? Can I save the result in my own table instead of the History table?

|||

You need to call SetReportParameters to set the parameters. The history snapshot will be saved to the History table. Can you explain why you would want to save it elsewhere?

-Daniel

|||I was planning to use my own database to save the snapshot for ease of maintenance and backup, besides, using the SnapshotDate and converting it to another format before using it is extar work! I guess I can use the RS History Table for now. One thing though, when I get a snapshot, the date in History table doesn't match with the snapshot date! Any idea why? Thanks.|||

I assume you mean the snapshot datetime stamp used as URL access parameter to render history snapshot. The snapshot datetime value is always based on UTC time which is independent of your local timezone, while the date in the internal catalog tables depends on your server timezone settings.

-- Robert