Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Creating Report Snapshot with parameters programat

Author  Topic  PeterNZ Starting Member 1 Post Posted - 2008-05-08 : 23:15:11 Hi forum, I like to ask for some input please. Our environment is SQL Server 2005 Reporting Services and we are using SSRS web services. We are creating a system where a batch process is creating report snapshots in a nightly batch run. Users then access these snapshots via a web UI the next morning. This works fine as long as the report doesn't have parameters. With report parameters I haven't found a way to do this without having to call the render method. If I look at the Execution Web Services they provide a LoadReport and then SetExecutionParameters methods. But there is no CreateHistorySnapshot method. This one is in the ReportServices web service. I know I could set up the reports so that every execution would create a snapshot but then I would have to use the render method which returns a byte array and would put unnecessary load on the network. So if anyone would have an idea i would appreciate if you would answer. Cheers Peter