Sending field parameters to SSRS action link

Question

I was trying to pass field parameters to Action Link in SSRS like, http://mysite.aspx?id="+Fields!ID.Value

but it is saying as, Input String was not in a correct format. When i tried with the format as http://mysite.aspx?id=10(10 is static not dynamic). It is not showing any error.

Please tell me what i can do, as i'm struck up with this issue.

Thanks in Advance, Raghava.

Manish Mishra · Accepted Answer · 2013-03-28T13:01:17.143

7

right click the field you want to make hyperlink and select TextBox Properties, and then go to Action tab in the popup that appears.

and choose Go To Url option and click on expression and set the below given expression.

="http://mysite.aspx?id=" & Fields!ID.Value

it should work.

enter image description here

edited Mar 28 '13 at 13:01

answered Mar 28 '13 at 12:54

Manish Mishra

12,163
5
35
59

Hi Manish,Thanks for answer. What if i have to pass multiple parameters. Like id=Fields!ID.Value&Name=Fileds!Name.Value – user2219742 Mar 29 '13 at 05:51
`="http://mysite.aspx?id=" & Fields!Id.Value & "&Name=" & Fields!Name.Value`. this is your expression. – Manish Mishra Mar 29 '13 at 06:07
notice, the fragments inside double quote. you are basically concatenating multiple strings. – Manish Mishra Mar 29 '13 at 06:08
Guys, when I use the format describe above, the field is no longer a link. Any ideas why? – Victor_Tlepshev Apr 02 '19 at 13:13

Sending field parameters to SSRS action link

1 Answers1

Linked