Good morning Tessi community!
I have been developing a number of SSRS reports and was hoping someone could enlighten me on how to add functionality that allows the person running the report to click on the constituent ID and be taken to the record.
Any advice is greatly appreciated!
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=" & idEnd 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!