I have come across a critical issue in rolling out IA to my user base.

A simple report (just two BY fields) gets transformed into SQL with a MAX() column that has now column name. Column names are a requirement of my ODBC driver. Can I configure IA or my WFRS to add column names for the columns it adds? Here is the full text of the error message:

(FOC1400) SQLCODE IS 10300 (HEX: 0000283C) : [S1000] [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engi : ne]A column without a name was detected in the result set for procedure : SELECT T1.Container_Status,T1.Add_Date, MAX(T1.Container_Status) FROM db :
o.Part_v_Container T1 WHERE (T1.Add_Date >= {ts '2010-08-17 09:43:42'}) : GROUP BY T1.Container_Status,T1.Add_Date ORDER BY T1.Container_Status,T1 : .Add_Date.
Please use an alias for conditional and calculated columns.[ : 10300] L

(FOC1406) SQL OPEN CURSOR ERROR. : PART_V_CONTAINER

Like the man said, "use an alias":

 
... , MAX(T1.Container_Status) as max_status FROM ... 
                               ^^^^^^^^^^^^^  

Yeah, that works if I am writing the SQL, but when I am using IA with the GUI only (not even Editor), I don't have that option. I am looking for a way to get the "use an alias" message through to IA or deeper in the WF stack to the WFRS.

WF is adding the column without an alias, not me the IA user.