• Replies 3 replies
  • Subscribers 414 subscribers
  • Views 11 views
  • Users 0 members are here
Related

Venue Collection Reports

Amanda Fairbairn
$organization

Trying to find out how many tickets were ‘venue collection’ (and which venue), and how many were counter (i.e. walk ups).

Ran single sale order listing report, with the same parameters and it’s coming up with different numbers compared to when I run a sql query on the T_order tables.

Any suggestions?

  • $organization

    Hi Amanda,

    Good day.

    I am not sure what you try to get.

    but if you run SQL profiler and catch the sql statement, then you will always get the same results from sql query windows.

    when you run single sale order listing report, it is running something like this in SQL server:

    execute dbo.RP_RESTOPAY   @mos_str = NULL, @location_str = NULL, @perf_dt_start = {ts '2010-02-01 00:00:00.000'}, @perf_dt_end = {ts '2010-03-31 23:59:59.997'}, @delivery_str = NULL, @ord_dt_start = {ts '2008-03-01 00:00:00.000'}, @ord_dt_end = {ts '2012-03-03 23:59:59.997'}, @paid_flag = 'All', @printed_flag = 'All', @seated_flag = 'All', @list_no = NULL, @channel_str = NULL

     

    have fun.

    Ben

  • $organization in reply to Ben Gu

    Hey Ben

    Thanks for this, it helped a bit.

    Cheers

    Amanda

  • Former Member
    Former Member $organization
    Hi, can you share your SQL query used for comparison as well as the parameters and report name used when running your Tess report?  Are 'venue collection' and walk up different modes of sale? Is that the analysis you are looking for--a MOS comparison? For all price types cats (or groups) or something specific?

    On Mar 2, 2010, at 2:27 PM, "Amanda Fairbairn" <bounce-amandafairbairn1420@tessituranetwork.com> wrote:

    Trying to find out how many tickets were ‘venue collection’ (and which venue), and how many were counter (i.e. walk ups).

    Ran single sale order listing report, with the same parameters and it’s coming up with different numbers compared to when I run a sql query on the T_order tables.

    Any suggestions?




    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!