Solved

Running report in SSRS 2008 R2 from the command line

Posted on 2011-03-25
2
924 Views
Last Modified: 2012-05-11
How do I run a report in SSRS 2008 R2 from the command line, passing in parameters?
For example if my report is

servername = myserver
reportname = myreport
parameters = begindate, enddate, so_number
0
Comment
Question by:bmorriso99
2 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 35222704
Can be done with RS, and then run at the cmd line like this:
rs –i c:\scriptfiles\script_copycontent.rss -s http://localhost/reportserver

Check this out:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1398b94a-be3b-4943-8305-2e7e2b7cca05/
0
 

Author Comment

by:bmorriso99
ID: 35244187
I can see that you can do many things with scripting and I understand the command line argument but I cannot find what to do in the script to actually run the report. Is it the 'render' command?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now