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
Jean,
That was the perfect solution – thank you!
Jim DeGood
Director of Marketing and Communications
Lyric Opera of Kansas City
Please note new mailing address:
1616 Broadway | Kansas City, MO 64108
direct dial phone: 816-802-6062
main phone: 816-471-4933
main fax: 816-471-0602
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Jean RiversSent: Friday, October 07, 2011 1:40 PMTo: Jim DeGoodSubject: RE: [Tessitura Next Generation Forum] Reporting using Price MAPS
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
You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!