Adding clickable fields in SSRS

Unknown said:

how to add functionality that allows the person running the report to click on the constituent ID and be taken to the record.

Placeholder properties -> Action -> Go To Url.

Expression:

=Code.GetTessituraLink("Constituent", Fields!customer_no.Value)

I am getting this error when I try to preview the report:

Error [rsCompilerErrorInExpression] The ActionInfo.Action.Hyperlink expression for the text box ‘HHid’ contains an error: [BC30451] 'Code' is not declared. It may be inaccessible due to its protection level.

Could this be a permissions issue?

Unknown said:

'Code' is not declared. I

Ah, my tip assumed some code added to your template; it's been in mine so long I'd forgotten all about it. See Report -> Report Properties -Code, and add

Function GetTessituraLink(resource as String, id as Long) As String
    If NOT Report.Globals!RenderFormat.IsInteractive Then
        RETURN Nothing
    End IF
    If NOT (len(resource) > 0) OR id < 1 Then
        RETURN Nothing
    End If
    
    RETURN Report.Globals!ReportServerUrl & "?/Tessitura/Links/" & resource & "&Id=" & id
End Function

Highly recommended to add this to your template(s), and then forget about it, like me. :-)

Unknown said:

'Code' is not declared. I

Ah, my tip assumed some code added to your template; it's been in mine so long I'd forgotten all about it. See Report -> Report Properties -Code, and add

Function GetTessituraLink(resource as String, id as Long) As String
    If NOT Report.Globals!RenderFormat.IsInteractive Then
        RETURN Nothing
    End IF
    If NOT (len(resource) > 0) OR id < 1 Then
        RETURN Nothing
    End If
    
    RETURN Report.Globals!ReportServerUrl & "?/Tessitura/Links/" & resource & "&Id=" & id
End Function

Highly recommended to add this to your template(s), and then forget about it, like me. :-)

Agreed.  Like the infomercials say, "Set it and forget it".  This is gold to have in your templates.

Awesome! Thank you, Chris. This is working perfectly!