Friday, 24 June 2016

Hyperlink in SSRS for MDX report

Hyperlink
 This project required us to use hyperlinks for Excel and PDF icons to open reports in Excel and PDF respectively. Oracle reports worked as expected but MDX report did not work properly. This is because the data which was passed in the hyperlink was included in brackets[]. We had to replace the [ with the %5B symbol to overcome this issue

="&Globals!ReportServerUrl&/Pages/Report.aspx?%2fScheduled+Reports%2fFoods%2fDaily+Summary+Dashboard%2fPhase+2%2fLongLife%2fAvailability%2fLong+Life+Department+Detail(ProductClass+Group)&pGroup=" & Replace(Replace(Replace(Fields!GroupLabel.Value,"[","%5B"),"]","%5D"),"&","%26") &"&pProductClass=" & Replace(Replace(Replace(Parameters!pProductClass.Value,"[","%5B"),"]","%5D"),"&","%26") &"&rs:Format=EXCEL"

No comments:

Post a Comment