a SP calls report to re-run
hi, Anyone knows how to run a SSRS report from s SQL stored proc? Thnaks in advancemecn
March 29th, 2011 12:20pm

Hi mecn, I think system store procedure for ReportServer DB can do that, but still not sure 100%. What are you trying to accomplish can you elaborate you req. please? Thanks KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 12:41pm

Thanks for replying. I need to have a Tsql SP calling a SSRS report to generate an excel report in a network folder. I can't schedule it because the Sp execution time could be vary.mecn
March 29th, 2011 2:18pm

Hi, a SSRS report to generate an excel report in a network folder. I recommend that you define a subscription by using Windows File Share delivery. To distribute a report to a file share, we define either a standard subscription or a data-driven subscription. Reports can be rendered in a variety of file formats, we can choose Excel to save the report as a Microsoft Excel file. For more information about File Share Delivery in Reporting Services, please see: http://msdn.microsoft.com/en-us/library/ms159264.aspx Thanks, Ai-Hua Qiu Ai-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 4th, 2011 4:52am

One more method http://dimantdatabasesolutions.blogspot.com/2009/02/how-to-render-report-to-pdfexcel-format.htmlBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
April 4th, 2011 4:56am

As A-hua Qui suggested, create a subscription to generate a report and setup an associated schedule. Once you setup, you would notice it creates an SQL Agent Job. Ruunig this job causes the report to be generated fresh. You can call the agent job by EXEC msdb.dbo.sp_start_job 'SSRS_REPORT_GENERATION_JOB' Note : Replace the SSRS_REPORT_GENERATION_JOB with the correct name of the job. Usually the job name is mix of characters and number and around 36 characters long. Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
April 4th, 2011 5:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics