I try to open the URL from the SSRS by passing some parameters.
Most of the time, it works. But, when the parameter contains “+” and “/”, it will not work.
Example: when i have Fields!FAMILY.Value = “ACR+”, I will get “ACR+” appear on the link. But, the only way to get this work is to have the “+” = %2B”, when I change the link to “ACR%2B” the link manages to open as needed.
I try to do this dumb thing by replacing the “+” with “%2B” in the code but I still get “+” passing in the created URL link…
="javascript:void(window.open('http://" & "pl-ate/ReportServer/Pages/ReportViewer.aspx?%2fProduct+Reports%2fNPI+Yield+Report&rs:Command=Render" & "&Family=" & Replace(Replace(Fields!FAMILY.Value, "+", "%2B"),"/","%2F") & "&SITE=" & Fields!SITE.Value & "&startTime=" & Format(DateAdd("m", - 3, Today), "yyyy-MM-dd") & " 00:00:00" & "'))"