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?
The only thing that pops immediately to mind is that you might need to use "!." in front of your column name so when output set builder constructs the query it knows to alias that field.