Reporting Actions and Parameters issues

[RiverGuy]

Using SSAS 2008 Enterprise. I've got some reporting actions where I pass in member names as parameters to SSRS reports. Often, these actions do not work when called from Excel. I believe the main issue is the fact that the names of these members contain special characters which are invalid for a URL query string. Does anyone know of a catchall workaround to format these strings correctly?

Thanks

 

[MDXer]

I forget the function but there is something like a URL or HTTP Encode which will format he special characters in your querystring.

 

[RiverGuy]

I guess the function is called UrlEscapeFragment. Here's the answer I got at MSDN.

http://social.msdn.microsoft.com/Fo...s/thread/bd61ff9c-f2fc-4d65-bf13-7c3b9579c7df