Hello All,
I would like to create a report using Constituency & Constituency code. Has anyone created such a report and would be kind of enough to share it with me how you’ve done so?
Thank you, kindly.
Darnell
Hi Darnell,
The Constituencies are stored in TX_Const_Cust, the definitions are in TR_Constituency. If you want constituencies to appear as a single line like they do on a Patron header then you need to use something like Const_Codes = [dbo].FS_CONST_STRING_NEW(a.customer_no, 'Y').
One of the things I find useful when trying to come up with a report on an area I do not spend a lot of time in is to use the Tessitura Screens Table Reference V12. The other document I find of value is the Conversion Layouts.
Hope this helps
Peter