Hi Guys
We are trying to compare two Groups on sale dates against each other and the total number of Reservations that where made on one particular day. I think that the only way that we can get the total number of reservations for a day is using T_ORDER_SEAT_HIST but I'm having problems getting correct figures.
Have any of you managed to put together a script that will give you an accurate number of reserves from T_ORDER_SEAT_HIST. I have tried looking at the RP_TICKET_SALES_BY_PERIOD report to get a good understanding of how to work out the roughly the correct figures but they aren't exact!
The closed I have got is using but I know this isn't right.
CASE when event_code = @event_code_new_paid and h.seat_no > 0 then -1 when event_code = @event_code_new_unpaid and h.seat_no > 0 then -1 when event_code = @event_code_returned and h.seat_no > 0 then -1 when event_code = @event_code_released and h.seat_no > 0 then -1 when event_code = @event_code_reserved and h.seat_no > 0 then 1END
Any pointers would be great
Thanks
Nick
Hi,
Did you ever get this working Nick?
I'm trying to write a procedure that tells people at any point in time, how many reserves and sales a show had. I've almost got it, there are a few figures out here and there and I've attributed it to changes in price types, mainly when this is combined with event 25, payment adjustments...
Ryan, I think the -1 was correct with Nick if he was trying to do the same as me. Once a seat becomes fully paid it is no longer reserved, so you want to subtract one from that column...