February 17, 2009 at 9:14 pm
Hi All,
I am having a set of SSRS reports 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>?
February 17, 2009 at 9:59 pm
Hi Raden,
Try using subscriptions in SSRS:
http://msdn.microsoft.com/en-us/library/aa237769(SQL.80).aspx
http://msdn.microsoft.com/en-us/library/aa237788(SQL.80).aspx
February 17, 2009 at 10:08 pm
There problem here is I have seperate criteria / input parameters to the SP returing data to SSTS Report. I am not sure how do we feed the input params to the Subscriptions?
February 18, 2009 at 8:57 am
The report parameters values have to be specified at the time when the subscription is created.
http://msdn.microsoft.com/en-us/library/ms157306(SQL.90).aspx
February 18, 2010 at 5:58 pm
Grasshopper, Thanks for the links!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply