sql server reporting services: How can I pass parameters into an RSS file for RS.EXE -- sql server reporting services

How can I pass parameters into an RSS file for RS.EXE

AdamB
8/27/2004 1:53:10 PM

sql server reporting services:

I have a stored proc running:

Declare @cmd nvarchar(255)
Set @cmd = 'C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rs -i
"C:\CmdLineReportRendering.rss" -s http://localhost/reportserver

exec master..xp_cmdshell @cmd

But, the report the RSS file will render has 3 parameters the user specifies.

I know I can easily pass parameters to the command line from my stored proc,
but can I pass parameters from the command line into the RSS file like I can

Re: How can I pass parameters into an RSS file for RS.EXE

Lev Semenets [MSFT]
8/28/2004 6:41:27 PM

the syntax is
-v parameter1Name="parameterValue"

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]