SSRS int parameter passes to sub report as text

Question

I'm using SSRS 2012 and I'm trying to pass an integer value (ItemKey) from my first report to a parameter (prmItemKey) in a second report that opens in a new window.

The second report opens up as expected, but instead of receiving the passed value it receives the name of the field as text.

="javascript:void(window.open('http://rd-sql.rossdown.local/ReportServer?%2fSupportFolder%2fItem+Details&rs:Command=Render&prmItemKey=Fields!ItemKey.Value'))"

The parameter prmItemKey is expecting an integer, and the report returns a type mismatch error when it receives Fields!ItemKey.Value as text.

Trubs Trubs · Accepted Answer · 2015-06-03T23:46:24

I expect its actually passing the text 'Fields!ItemKey.Value' in your querystring to your Linked report.

You'll need to expand your Fields!ItemKey.Value before you put it in the querystring

="javascript:void(window.open('http://rd-sql.rossdown.local/ReportServer?" &
  "%2fSupportFolder%2fItem+Details&rs:Command=Render&prmItemKey=" & 
  Fields!ItemKey.Value & "'))"

[edit] added clarification to make the solution easier to find. (thanks Dan)

SSRS int parameter passes to sub report as text

1 Answers