Colleagues,
Is anyone successfully and in a stress-free manner running reports on revenue generated by looking at price maps as opposed to (or in combination with) price types? If so, I'd love to know how you accomplish it.
Many thanks,
jd
JD,
Have you looked at the Transactions by Posting report? It returns price map information.
I also know that the t_transaction table stores price map number and performance number. Maybe you can have a view of the information you need built.
Sometimes it is easier for me to manage reporting challenges in Excel. I’ve had good success connecting the Tessitura database information to Excel pivot tables using the data connection feature. It is very flexible. You can query the database to return the information you want.
Jean J. RiversControllerSan Jose Repertory Theatre101 Paseo de San AntonioSan Jose, CA 95113t: (408) 367-7286f: (408) 367-7237e: jeanr@sjrep.comwww.SJREP.com