0

Hello I have ssrs report and I want to pass parameters within URL is it possible?

report link: http://serverName/reports/reportname

it is possible when I access link like below http://servername/ReportServer/Pages/ReportViewer.aspx%2fReportName&rs:Command=Render&ParamerterName = abc but I want to achieve for link http://serverName/reports/reportname

can someone please help

1 Answers1

0

This is a variant I use. This passes concatenated parameters/one parameter from a cell in Excel to the SSRS report (each parameter separated by "-") and opens the report in another Excel workbook. The SSRS report is coded to split the parameter into its constituent parts.

http://myserver/Pages/ReportViewer.aspx?%2fMyreports%2fmyfolders%2fmyreport&rs:Command=Render&rs:format=EXCEL&rc:target=_blank&myparam=xxxxx
MiguelH
  • 1,415
  • 1
  • 18
  • 32