Has anyone here edited the standard Infomaker report Ticket Sales by Period? We are starting to depend on that report, but the standard sort order does not work for us; it needs to be sorted by performance date/time. We are self-hosted, and I do have a licensed copy of Infomaker 2017 R3, but it has been a while since I have modified reports, and then only custom reports.
Clarke
To follow up on this old issue, I never did get around to building a new SSRS report, nor was I able to find the Infomaker file that Tessitura uses actively. I did find the stored procedure that powers the report (RP_TICKET_SALES_BY_PERIOD), but the procedure has no control over sorting in the report.
However, I did find the Infomaker file included with our latest upgrade (d_ticket_sales_by_period within LibrariesAndSamples\TessituraSampleLibrary\Standard Reports\reportsticketingboxoffice.pbl). I saved it as ld_ticket_sales_by_period into our custom reports, modified it to sort correctly (Rows/Edit Group/2/Group sort), and created a new report with a new name exactly like the original but referencing the modified Infomaker file.