asked on 2/8/2019

Display SSRS linked report in new tab passing parameters.

Have a report in SSRS that I've added a link to another report within a textbox using "Go to URL" because wanted to open in new tab. The below code will open the report but doesn't pass the parameters:

="javascript:void(window.open('https://servername/RsMgt/Pages/Report.aspx?ItemPath=%2fInventory+Data%2fActivity+Lifespan&rs:Command=Render & Fields!Location.Value & Fields!SN.Value'))"

Any ideas what I'm doing wrong?
on SQL Server 2008 R2.

SSRS Microsoft Server OS Microsoft SQL Server

Last Comment

MadIce

3/21/2019

irudyk

2/10/2019

Try the following which places the field values outside of the string you are building between the ""

="javascript:void(window.open('https://servername/RsMgt/Pages/Report.aspx?ItemPath=%2fInventory+Data%2fActivity+Lifespan&rs:Command=Render" & Fields!Location.Value & Fields!SN.Value & "'))"

irudyk

2/11/2019

Just curious if you had any luck with the above suggestion?

MadIce

2/11/2019

ASKER

Thank you for the reply irudyk. I tried before what you suggested but couldn't get it to work. This is how I got it to work:
="javascript:void(window.open('https://servername/ReportServer/Pages/ReportViewer.aspx?%2fInventory+Data%2fActivity+Lifespan&rc: Command=Render&Dodic=" & Fields!Location.Value & "&Lot=" & Fields!SN.Value & "'))"

I switched to ReportServer vs RsMgt. not sure If that mattered but changing from RS to RC did right before Comannd=Render.

Not sure what the difference is. Tried to research. So this difference in an example. Worked for me.

ASKER CERTIFIED SOLUTION

MadIce

3/21/2019

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial