Hello all,
Has anyone devised and easy (and inexpensive) way of printing the 3 character short description of a Constituency on a ticket?
Hi Darrell
Needs a little back-end work, but its not hard to do, if you have access to some basic SQL skills.
You can create a user-defined ticket element by modifying the proc LP_TICKET_ELEMENTS, which you can then use on your tickets in the same way as the pre-defined elements.
And there's a function to use in your new element which will return the same string of constituency codes for a constituent that you get on the constituent header.
[dbo].[FS_CONST_STRING_NEW] (@customer_no int, @include_affiliates char(1))
Your code would look something like this:
If @ude_no = 1 and @customer_no > 0
Select @ude_value = coalesce (left( [dbo].[FS_CONST_STRING_NEW] (@customer_no, 'Y'), 30) ,'')
Ken