This is for all you Output Set experts out in Tessi land.....because I am far from it!!
What causes a message about an ambiguous column when trying to run the Output Set report? I've created an output set and one of the criteria that I'm using requires an element parameter. After selecting the parameter and running the report, I get an ambiguous column error message. I've edited the entry in tr_query_element to remove the Data Where column entry and the element requirement is removed and I can run my report...but that's not what I want to do because then I get lines in my output that I don't want. What causes the error and how can I fix it?
What are all of the fields in your output set? Any of them named the same?
Marty Jones
Database Administrator
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469 | F 402.345.0222
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Teresa Dean Sent: Thursday, September 09, 2010 8:21 AM To: Martin A. Jones Subject: [Tessitura Technical Forum] Output Sets - Ambiguous Column
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!