Post reply

Passing MDX values to drill through report using MDX parameter

  • June 7, 2014 at 3:02 pm

    #307975

    Hi,

    I need to pass 2 parameters (which is coming from MDX dataset) into another report which again is using the MDX parameters to show detail report.

    I'm using this expression in Go to URL... somehow the drill through report works while passing one parameter (Date.CalendarYear or Employee.UserName). But when I pass both Year and UserName, it assign the value to Year but UserName parameter is not getting the value assigned from main report.

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

    PS: I'm using escape() since '&' in the unique value like [Date].[Year].&[2014] is throwing URL exceeds 260 chars error.

    Plz can you check this and let me know if there's any issue with the expression.

    Cheers!

    Suresh

  • June 15, 2014 at 4:53 pm

    #1721821

    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'))"

    Suresh

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply