Home Forums Reporting Services SSRS 2012 Passing MDX values to drill through report using MDX parameter RE: Passing MDX values to drill through report using MDX parameter

  • June 16, 2014 at 12:02 am

    #1721838

    Suresh.Utham (6/15/2014)

    I found the solution for this in another blog... Used replace(Param.value, "&[", "%2526[") instead of escape() and it worked 🙂

    ="void(window.open('"+Variables!ReportServerUrl.Value+"/Pages/ReportViewer.aspx?"+Globals!ReportFolder+"/Test+Report&rs:Command=Render&Param1='" + replace(Fields!Realname.Value, "&[", "%2526[") + "&Param2=" + replace(Fields!Username.Value, "&[", "%2526["),'_blank'))"

    Good that you found the solution and thanks for posting it here.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP