Solved

Running report in SSRS 2008 R2 from the command line

Posted on 2011-03-25
2
934 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

707 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