• Replies 3 replies
  • Subscribers 414 subscribers
  • Views 13 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?

Parents
  • $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

Reply
  • $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

Children