We are trying to automate some ticket reports for our finance office by creating custom SSRS reports. These reports would be automated and saved daily to a local server for staff to view. But in the event that something happens and a report is not saved properly we'd want to go back and run the report again for all the data up to that point in the database. So far we have found a way to do this for ticket income and sales, but we also want to report on tickets held and available at that time. Right now we get these numbers from TX_PERF_SEAT, but obviously that only reports on the most current seat status so it wouldn't give us an accurate number from a previous date. I imagine we would need to use T_ORDER_SEAT_HIST but I can't seem to wrap my head around how to accurately count all the separate events to get the right number for a previous business date.
If anyone has experience with reporting this data, I would love some insight into the matter.