This is essentially the same bug as 0001169 but I can't change the category to iReport NB
The query designer attempts to use an output-column alias in the GROUP BY clause which causes a problem with the Oracle JDBC driver. In Oracle you cannot use aliases in the GROUP BY section.
If tried Oracle returns
"Error:SQL problems:ORA-00904: "ALIAS_NAME_HERE": invalid identifier