Report needed?

Hello,

I am looking for a report that gives me a list of patrons who paid by a certain payment method for a specific performance? Is there one that exists currently in Tessitura?

 

Thanks!

  • Hi Amy

     

    We have a customised Seating Book report that includes extra detail about the customer and Order, including the payment method used.

    So while its not a parameter you can the results save to Excel and sort/filter by Payment Method in the raw data.

     

    Let me know if that would be helpful.

     

    Regards

    Peter

     

    Peter Nelson

    Business Analyst, Information Systems

    T 02 9250 7180  M 0401 714 246 

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    SOH_LOGO.gif

    FACEBOOK.gifTWITTER.gifYOUTUBE.gifBLOG.gif

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amy Aldrich
    Sent: Tuesday, 30 August 2011 02:35
    To: Peter Nelson
    Subject: [Tessitura Ticketing Forum] Report needed?

     

    Hello,

    I am looking for a report that gives me a list of patrons who paid by a certain payment method for a specific performance? Is there one that exists currently in Tessitura?

     

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
    Please consider the environment before printing this email.

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
  • Hey Peter,

    We would love this report too!

    Beau.

  • Hi Beau/Amy

     

    I’ve added the components to a folder on my profile (sql script, report pbl and report xml).

    Note it does include a number of local customizations which you will need to consider when implementing. Ive included some of them in the ‘readme’ file, but feel free to contact me directly if you need more info.

     

    Peter

     

    Peter Nelson

    Business Analyst, Information Systems

    T 02 9250 7180  M 0401 714 246 

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    SOH_LOGO.gif

    FACEBOOK.gifTWITTER.gifYOUTUBE.gifBLOG.gif

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Beau Vigushin
    Sent: Thursday, 1 September 2011 10:57
    To: Peter Nelson
    Subject: RE: [Tessitura Ticketing Forum] Report needed?

     

    Hey Peter,

    We would love this report too!

    Beau.

    From: Peter Nelson <bounce-peternelson1130@tessituranetwork.com>
    Sent: 8/31/2011 6:49:52 PM

    Hi Amy

     

    We have a customised Seating Book report that includes extra detail about the customer and Order, including the payment method used.

    So while its not a parameter you can the results save to Excel and sort/filter by Payment Method in the raw data.

     

    Let me know if that would be helpful.

     

    Regards

    Peter

     

    Peter Nelson

    Business Analyst, Information Systems

    T 02 9250 7180  M 0401 714 246 

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    Error! Filename not specified.

    Error! Filename not specified.Error! Filename not specified.Error! Filename not specified.Error! Filename not specified.

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Amy Aldrich
    Sent: Tuesday, 30 August 2011 02:35
    To: Peter Nelson
    Subject: [Tessitura Ticketing Forum] Report needed?

     

    Hello,

    I am looking for a report that gives me a list of patrons who paid by a certain payment method for a specific performance? Is there one that exists currently in Tessitura?

     

    Thanks!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
    Please consider the environment before printing this email.

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
    Please consider the environment before printing this email.

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
  • Hi Peter,

    I notice in your post that you have a custom seating book report you were offering to share.

    I'm looking for a seating Book that reports on the following for a specific performance. The current report doesn't pull address detail and I wonder if the custom report you mention in your post contains address detail and if you comfortable sharing the report?

    Customer_fname 
    Address_street1
    Address_city
    Address_postal_code
    Ticket Order Date
    Ticket Price Type 
    compute_0009 
    compute_0010
    Ticketing Performance Name

    Kind regards

    Justin Cheek 

    Perth Festival