I'm working on linking Tessitura profiles with an outside database system. The system uses their own constituent IDs in URLs, which is fantastic because they're all unique. However, it's not so fantastic because they're completely different from our Tessitura IDs.
What I'd like to do is create a browser-based T_CONSTITUENT_REPORT row that includes the outside database's ID in the dynamic URL. Something like:
D Object: http://www.databasething.com/seattlesymphony?profile=<<outside_key>>
Anyone know if there's any way of doing that, or something like it? Is the only alternative to do an SSRS report that then links to the ResearchPoint profile? Trying to make this simple for the end user, so advice is appreciated...thanks!
Andrew
Hi Andrew,
Have you taken a look at the stored procedure LP_PREPROCESS_URL?
Report and custom screen URLs are passed to this proc before rendering the object, perhaps this can help?
Cheers,
Patrick.