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  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Executing / Calling SSRS Report from SP for batch

Author  Topic  nraden Starting Member 1 Post Posted - 2009-02-17 : 23:20:08 Hi All, I am having a set of SSRS reports (SQL Server 2005) that generate xml and are currently called by a .NET front end by a user. We want to make this as a batch processing withut user inntervension and keep toise xml files ready at some location wher they can be downloaded. Can someone help me understand how I call/ execute SSRS Reports in background in batch and create a xml and save it at the given location. I can set u a SQL Job for doing this but am not sure how do I call / Execuet a SSRS report using a SQL Stored Procedure. ANy pointers / suggesitons>?