I am ffacing some problems on JasperReports Server 5.5 with Oracle Database when creating/using crosstab AdHoc Views. Adding a measure field to a crosstab column will result in a ORA-00979: not a GROUP BY expression. Jasper is performing a select for all displayable fields for the adoc report view; with a group by expression on chosen row/columns fields; with results in the ORA-00979. This same type of reports works with no problems on JasperReports Server 4.7.1 also connected to Oracle Database Test Case 1) Create a a simple domain referencing one or twa tables with some relation betwwen them 2) Create and Ad Hoc view, using that domain, using the two tables and crosstab type 3) Add measure filed to group column 4) Change on added field measure "Summary Function" from "Count All" to "Disinct Count", the error will happen