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. :-)

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

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