I keep getting an error on deployment where setting a hyperlink expression on customer_no to the recommended syntax of: =Code.GetTessituraLink("Constituent", Fields!.customer_no.Value)
Halts any deployment. The report definition has the custom code in the properties. Any Ideas?
Yep! That was it…. I knew it was something like that… Thanks.
---
Regards,
Troy Nelson
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur GrundstromSent: Monday, August 27, 2012 5:18 PMTo: tnelson@smm.orgSubject: RE: [Tessitura Technical Forum] Adding hyperlink to customer number SSRS
Troy has a period after the exclamation.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris JensenSent: Monday, August 27, 2012 6:01 PMTo: Brian W. GrundstromSubject: Re: [Tessitura Technical Forum] Adding hyperlink to customer number SSRS
I'm not (yet) sure why, but for me, in some cases this works:
=Code.GetTessituraLink("Constituent", Fields!customer_no.Value)
...and in some cases this works:
=Globals!ReportServerUrl & "?/Tessitura/Links/Constituent" & "&Id=" & Fields!customer_no.Value
From: Troy Nelson <bounce-troynelson3148@tessituranetwork.com>Sent: 8/27/2012 3:00:04 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
I've never done this, but am very interested in putting this into my reports. Do I just put this expression right into my customer_no field? Do I need any additional procedures added to the report? Any direction you can provide would be awesome.
Thanks,
Steve
I think I may have figured it out. I used the following in the Action>>Select URL property, and so far it seems to be working great.
Hi Steve!
You'll need to have some code embedded in your report (likely it will be there if you use the v11 template that Tessitura provides - otherwise you'll want this in your template so it will apply to any new report you make).
When your template or report is open, go to the Reports menu at the top, and click on Report Properties. Click on the "Code" tab on the left, and you should see (or insert) this:
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
End If
RETURN Report.Globals!ReportServerUrl & "?/Tessitura/Links/" & resource & "&Id=" & id
End Function
Then you can select any Text Box or Placeholder (doesn't even have to be the customer_no - I often use that as well as the name field) and go to the Properties pane for that TextBox/Placeholder. Click the "Action" tab on the left, and choose the "Go to URL" button. In the Select URL field, type/paste the following:
Where it says "customer_no", that needs to be the EXACT (including upper/lowercase if applicable) same name as the field in your dataset that represents the customer number value. The "Constituent" part of the phrase means it will open the constituent window. Other options are "Contribution" and "Order" - if you provide the applicable order or ref no. Those will open smaller detail windows about a gift or order.
=Code.GetTessituraLink("Contribution", Fields!ref_no.Value)
=Code.GetTessituraLink("Order", Fields!order_no.Value)
You probably already know this - but this will only work when you are in the Tessitura client - not in web reports in a browser or in a PDF/email.
Bonus round - If you get really brave, I've also found ways to use the Action/URL entry from an SSRS report to start an email (like mailto) and even a link to create a gmail calendar entry. Good times!
Hope that helps.
Beth