Pass SSRS parameters into Drill through report VIA url

520 Views Asked by At

Im having trouble passing multiple parameters to my drill though report using an url.

I have got a single one working however when i try to add the next one it doesn't like what i have put.

 ="http://rpt.Test.local/ReportServer/Pages/ReportViewer.aspx?%2f%5bQuote+Tool%5d%2fChange%20Elec%20Split&PC="&Parameters!PC.Value

Above is the working one parameter and im now trying to add MTC = Parameters!MTC.Value.

Just think im imputting wrong.

Cheers

1

There are 1 best solutions below

0
On

Try this one.. almost there but just a small tweek:

="http://rpt.Test.local/ReportServer/Pages/ReportViewer.aspx?%2f%5bQuote+Tool%5d%2fChange%20Elec%20Split&"&PC=" &Parameters!PC.Value &"&MTC=" & Parameters!MTC.Value & "&rs:Command=Render"