I am sure there is a way to call reports from C# code and store them as a snapshot on the SQL Reporting Server. Can anybody refer me to an article or website on how this is done?
Thanks for the information.
Have you tried using a reportviewer component? I'm not exactly sure what you're asking for.
http://www.microsoft.com/downloads/details.aspx?familyid=F38F7037-B0D1-47A3-8063-66AF555D13D9&displaylang=en
|||I know what you are saying, but we have a batch process that uses stored procedures that will calculate aggregates (we are not using OLAP right now). This is a process that will probably take overnight to complete. We are calling this process from code and on completion of the process, we would like the report to be automatically generated and stored as a snapshot. We need all of the pre-processing to happen during this batch process. We don't want the report to be generating the aggregates. A couple of these reports will be about 1,000 pages long. They are yearly summary reports.
The UI will have a button to Queue the batch process and store it in a queue with other batch processes. I just need to figure out how to have the code call the report and store it as a snapshot when the process is complete.
Thanks for the information.
|||So you want the snapshot funtionality that report manager uses to be run from your code.
http://technet.microsoft.com/en-us/library/ms159217.aspx
