Hello
I would like to pull a seating book report for a concert to see who is attending that event, so I'd like it to list Constituent codes so I can identify donors/people of note.
I can't seem to find a way to include Const codes in this way either in this report or through an Output Set.
Does anyone have any genius ideas?
Thanks, Alison
Hi Alison
Have you tried using the FS_CONST_STRING function to pull this data? It is used (I think) to produce the list of constituency codes seen in the main header but can also be used in an output set and probably a report too (although I haven't tried this myself).
Feel free to email me direct if you like
Siobhan
Hi Siobhan
Thanks for such a quick reply! No, I haven't tried this so I'd love to know more about how to go about this. Can you share on the forum in case it helps others or would you prefer to chat via email?
OK. For use in an Output set, we did the following:
1.In the TR_QUERY_ELEMENT system table, add a new row
2.Enter the following:
Description: Customer Constituencies
Category: Constituent
Data Select: impresario.dbo.FS_CONST_STRING(customer_no)
Data From: T_CUSTOMER
Data Where: *leave blank*
Control Group: Add to a control group if you like
Single Row: Ticked
You should then be able to use this as criteria when building your output set.
Here is a very simple select to show you how to use this function in a report:
select customer_no, 'const' = dbo.fs_const_string(customer_no)
from t_customer (nolock)
where customer_no=10194857
Output reads: 10194857 DDS,VOL
You should be able to slot this into a custom seating book to get the output you need.
I hope that helps
That's great - thanks, Siobhan. I'll have a go with this and see how I get on.
Cheers
Alison