using OLEDB provider IBMDADB2.1
and the following SQL run from ReportBuilder
sect.name as Team,
tasktype.name as TaskType,
The SQL runs fine in a DB2 query tool but when run through ReportBuilder I get
[DB2/LINUXX8664] SQL0119N An expression starting with "TASKTYPE" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function
and no GROUP BY clause is specified. SQLSTATE=42803
Basically the problem seems to be related to grouping by on columns with the same name in different tables.
Anyone know a work around?
View Complete Post