Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / July 2008

Tip: Looking for answers? Try searching our database.

Problems Passing MDX Parameters     through “Jump to URL”

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MichaelS - 01 Jul 2008 23:09 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.