bruno.fs.antunes Posted July 8, 2014 Share Posted July 8, 2014 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 Case1) Create a a simple domain referencing one or twa tables with some relation betwwen them2) Create and Ad Hoc view, using that domain, using the two tables and crosstab type3) Add measure filed to group column4) Change on added field measure "Summary Function" from "Count All" to "Disinct Count", the error will happen Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now