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.
Unknown said: 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. =Globals!ReportServerUrl & "?/Tessitura/Links/Constituent" & "&Id=" & Fields!customer_no.Value
Yep - that works too, if you are avoiding putting the code I posted into each report. I think that's the difference that Brian posted about above.
Beth
Does the code only work for elements in the consitutent record? What about performances in Production Elements by using perf_no, for example?
Cheers,
Kevin
Hey Kevin,
You want to check out the Custom Report Setup document. Linkable resources are Constituent, Order, Contribution, and Issue (aka CSI).
Thanks, Nick! I had a squiz at that earlier today and was hoping the list of linkable resources would be a little longer :)