[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 948
  • Last Modified:

Running report in SSRS 2008 R2 from the command line

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
bmorriso99
Asked:
bmorriso99
1 Solution
 
dbaSQLCommented:
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
 
bmorriso99Author Commented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now