Thursday, June 4, 2020

Create Hyperlink to Execute a Report in Another Browser Tab

Select a text box
Change the Text Color to DarkBlue
Add Underline (so it looks like a link)
Text Box Properties, Action, Go To URL

Expression

="JavaScript:void window.open('../../ReportServer?/REPORT%20FOLDER/REPORT%20NAME&PARAM_NAME=" & Parameters!P_QUARTER.Value & "&P_EMPLOYEE_NUMBER=" & IIF(IsNothing(Fields!TELLER_ID.Value), "-2", Fields!TELLER_ID.Value) & "&P_BRANCH=" & Fields!BRANCH.Value & "&P_BRANCH_LABEL=" & Fields!BRANCH_NUMBER_AND_NAME.Value & "');"