• Replies 5 replies
  • Subscribers 412 subscribers
  • Views 10 views
  • Users 0 members are here
Related

Seating book to include Constituent codes

Alison Marley
$organization

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

 

Parents
  • $organization

    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

  • $organization in reply to Siobhan Parker (Past Member)

    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?

    Thanks, Alison

  • $organization in reply to Alison Marley

    Hi Alison

    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

    Siobhan

Reply
  • $organization in reply to Alison Marley

    Hi Alison

    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

    Siobhan

Children