in

Prologika Forums

Business Intelligence to the Masses
Latest post 09-10-2006 9:38 PM by tlachev. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 09-07-2006 4:27 PM

    • geoff
    • Top 150 Contributor
    • Joined on 09-07-2006
    • Posts 2

    UniqueKey "&" Special Character and Reporting Services

    Ch 18 states a problem with using "Jump to Url" to link to other reports with the generated parameter value as the UniqueKey in OLAP  datasets.

    UniqueKey  uses an "&" to denote the member Key and this gets interpreted on the parameter string of the URL as the end of one parameter and the beginning of another.

    The solution I'm suggesting is to escape the "&" as %26 for direct addresses and double escape the "&" as %2526 for javascript  addresses.

     

                          By the way Reporting Services seems very useful for Analysis Services.

     

                                            Geoff
     

                                                                
     

  • 09-07-2006 5:06 PM In reply to

    Re: UniqueKey "&" Special Character and Reporting Services

    Have you tried the %26 encoding and did it work? At the time of writing the book I tried all sorts of hacks including %26 to no avail. I mentioned this to the SSRS and SSAS teams but no workaround was provided. I've noticed that the SSAS team has implemented the undocumented URLEscapeFragment() function to get around the same issue. The problem with SSRS though is that the browser "helpfully" unescapes the escaped & on the way out. Please let me know if you get it to work.
  • 09-08-2006 2:06 PM In reply to

    • geoff
    • Top 150 Contributor
    • Joined on 09-07-2006
    • Posts 2

    Re: UniqueKey "&" Special Character and Reporting Services

    Yes the %26 does work for Url addresses in the Jump to URL. %26 goes to & after the parameters are parsed. You need %2526 if you put a javascript routine in the Jump to URL because it gets processed by the browser twice. %2526 goes to %26 goes to &
  • 09-10-2006 9:38 PM In reply to

    Re: UniqueKey "&" Special Character and Reporting Services

    Thank you for solving this dilemma. %2526 did the trick. I attached a test harness that demonstrates how the sample Daily Product Sales.rdl (used in Chapter 18) can be called.
Page 1 of 1 (4 items)
Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems