SSRS go to url with a field value

[MondayISACurse]

I am creating a SSRS report with an action to open a new window with the URL

And I want to pass the filed value as a filter for the new pop-out window.

Below is the code I am using

="javascript:void window.open('" & Globals!ReportServerUrl
 & "/reportserver?" & Globals!ReportFolder & "/MyReport&TYPE="&Fields!TYPE1.Value & "&AREA=" &Fields!AREA.Value & "&STATE=" &Fields!STATE.Value &"','_blank','width=1500,height=750,scrollbars=yes,resizable=yes,toolbar=no,status=no,menu=no,top=20,left=15')"

And the table I am using is down below

• AREA	Running	Failed
  AREA 1	10	0
  AREA 2	12	2

Both "Running"/"Failed" are the value from 'STATE', the idea is when i click for eg.10 it will only shows the AREA 1 with Running, when i clicked 2 it will shows AREA 2 with Failed

(Please noted, i also add the similar code for AREA as well, (without the STATE) and it works perfectly, so im confused why the similar code failed this one.

I have parameter for STATE as well, but i tried using &STATE = "&parameter!STATE.Value it still failed.

And also, STATE only has 2 values ( "Running" & "Failed") there is no specific characters

Any helps on this?

[Sahir_Maharaj]

If none of these solutions work, please provide more details about the error message you are receiving and any other relevant information so that I can better assist.

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 😉

[Sahir_Maharaj]

If the problem persists, try testing the same code with hardcoded values to eliminate the possibility of issues with the field values.

[Sahir_Maharaj]

4. Consider using Server.UrlEncode method to properly encode the Fields!STATE.Value parameter before passing it as a filter.

[Sahir_Maharaj]

3. Try using CStr(Fields!STATE.Value) instead of just Fields!STATE.Value to ensure that it is properly converted to a string.

[Sahir_Maharaj]

2. Make sure that the Fields!STATE.Value parameter is properly formatted and contains a value when you are trying to pass it as a filter. For example, try adding a message box to show the value of Fields!STATE.Value before passing it as a filter.

[Sahir_Maharaj]

1. Ensure the STATE field exists in the table and that it has the correct values, "Running" and "Failed".

[Sahir_Maharaj]

It looks like the code is having issues with the Fields!STATE.Value parameter. Here are a few things to check: