I am having a problem with the “&” character when trying to pass MDX
Parameters through Jump to URL.
Originally the report worked fine using “Jump to Report” but the users
wanted the drillthough report to open in a new window. I found this java
script and I can get it to open a new window but when I try to feed the
parameters it errors out because of the “&” character in the parameter value
([Time].[Time Year Month].[Month].&[200701]). It appears to automatically
convert “[“ but has trouble on the “&.”
This will work but I need it to open in a new window
="http://RXX123/Reportserver?%2fCLCGlobalProdTest%2fPlan+vs+Actual+-+Sales+-+Consolidated&rs:Command=Render&FromTimeTimeYearMonth="&Replace(Parameters!FromTimeTimeYearMonth.value,"&","%26")
It produces the following working URL
http://chvpkntah3d222/ReportServer/Pages/ReportViewer.aspx?%2fCLCGlobalProdTest%2fPlan+vs+Actual+-+Sales+-+Consolidated&rs:Command=Render&FromTimeTimeYearMonth=%5BTime%5D.%5BTime%20Year%20Month%5D.%5BMonth%5D.%26%5B200701%5D
This does not work:
="javascript:void(window.open('http://
RXX123/Reportserver?%2fCLCGlobalProdTest%2fPlan+vs+Actual+-+Sales+-+Consolidated&rs:Command=Render&FromTimeTimeYearMonth="+Replace(Parameters!FromTimeTimeYearMonth.value,"&","%26")+"'))"
It produces the following URL:
http://
RXX123/ReportServer/Pages/ReportViewer.aspx?/CLCGlobalProdTest/Plan+vs+Actual+-+Sales+-+Consolidated&rs:Command=Render&FromTimeTimeYearMonth=%5BTime%5D.%5BTime%20Year%20Month%5D.%5BMonth%5D.&%5B200701%5D
I even wrote a function to convert & to %26 but it seems to convert the %26
back to & no matter what I do.

Signature
Michael J. Sidley, CPA
Senior Consultant
BearingPoint
EricM - 11 Jul 2008 22:35 GMT
Michael,
replace the & sign with a %2526.
The %26 will render prior to hitting the URL
by replacing the % with a %25 you render the %25 into the % and therefor
pass a
%26 in the parameter instead of an &
> I am having a problem with the “&” character when trying to pass MDX
> Parameters through Jump to URL.
[quoted text clipped - 19 lines]
> I even wrote a function to convert & to %26 but it seems to convert the %26
> back to & no matter what I do.