I'm having some trouble making a data cell in an SSRS matrix clickable to go to a URL, passing parameters.
I've done this many times before, but something about this expression is keeping the cells from being clickable.
Here's the expression I have under the "Go to URL" action in "Placeholder Properties":
="javascript:void(window.open('http://Server/ReportServer/Pages/ReportViewer.aspx?%2fParent%2fDashboardDetail&Resolved=" + Parameters!Resolved.Value + "&Contact=" + Parameters!Contact.Value + "&Category=" + Fields!Category.Value + "&Range=" + Fields!Range.Value + "', '_blank'))"
I've passed through multiple parameters using this same template with no issues. However, when I run this report, it runs fine, but the cells don't hyperlink.
Thanks!
I'm having some trouble making a data cell in an SSRS matrix clickable to go to a URL, passing parameters.
I've done this many times before, but something about this expression is keeping the cells from being clickable.
Here's the expression I have under the "Go to URL" action in "Placeholder Properties":
="javascript:void(window.open('http://Server/ReportServer/Pages/ReportViewer.aspx?%2fParent%2fDashboardDetail&Resolved=" + Parameters!Resolved.Value + "&Contact=" + Parameters!Contact.Value + "&Category=" + Fields!Category.Value + "&Range=" + Fields!Range.Value + "', '_blank'))"
I've passed through multiple parameters using this same template with no issues. However, when I run this report, it runs fine, but the cells don't hyperlink.
Thanks!
Share Improve this question asked Sep 12, 2013 at 15:24 Sev09Sev09 8732 gold badges12 silver badges27 bronze badges1 Answer
Reset to default 6Try using the toString() method on your parameters to convert them to a string so the + operand can concatenate them together.
So
Parameters!Resolved.Value
bees
Parameters!Resolved.Value.toString()