Can I execute an SSRS report from a windows batch file?

Posted by Christine on Server Fault See other posts from Server Fault or by Christine
Published on 2011-03-03T19:49:17Z Indexed on 2012/12/09 5:07 UTC
Read the original article Hit count: 552

Filed under:

ssrs-2008-r2

We are using SQLServer 2008R2 and would like to run and SSRS report from a windows batch file. We're loading data warehouse tables using a third party scheduler program and at the end our dataload we want to run a data quality report using SSRS. I can create report subscribtions to email the report but how do I communicate to the report server that the job is done and it's time to run the report? OUr scheduler application can run batch files so if I could pass this to the report server through a batch file that would be great...

Related posts about ssrs-2008-r2

How to enable SSIS as data source type on SQL Server Reporing Services SSRS 2008 R2

as seen on SQL Server Central - Search for 'SQL Server Central'
when you create a data source in SSRS 2008 R2 (Nov CTP), you won't be able to get SSIS listed as a data source type. Therefore applications that are already using it as a data source or applications that require it as a data source get stuck. Let's learn how to enable and get SSIS listed back as… >>> More
SharePoint 2010 Hosting - ASPHostPortal :: Installing SSRS 2008 R2 on SharePoint 2010

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
What do you need first? Please download SQL Server® 2008 R2 November CTP Reporting Services Add-in for Microsoft SharePoint® Technologies 2010 and please follow this steps: 1. Install a SharePoint technology instance. (Already did this when installing PowerPivot with SharePoint) 2. Install SQL Server… >>> More
Force SSRS 2008 to use SSRS 2005 CSV rendering

as seen on Stack Overflow - Search for 'Stack Overflow'
We are upgrading our report server from SSRS 2005 to SSRS 2008 R2. I have an issue with CSV export rendering for SSRS 2008 where the SUM of columns are appearing on the right side of the detail values in 2008 instead of the left side like in 2005 as shown in the below blocks. 117 and 131 are the sums… >>> More
Automating an SSRS 2008 R2 Report Snapshots and run report with most recent data

as seen on Server Fault - Search for 'Server Fault'
I would like to automate a report snapshot, but there is only an option to take a snapshot in the Report History Tab. All the resources I've found suggest I need to go to processing options and select "Render this report from a snapshot". But I don't want to do that - when I go to a report, I want… >>> More
Can I execute an SSRS report from a windows batch file?

as seen on Server Fault - Search for 'Server Fault'
We are using SQLServer 2008R2 and would like to run and SSRS report from a windows batch file. We're loading data warehouse tables using a third party scheduler program and at the end our dataload we want to run a data quality report using SSRS. I can create report subscribtions to email the report… >>> More

Developer IT