luciano_castro

hi iancr01 ! The query is fine, actually any query that i use produces the error, even the easiest ones like 'select id from my_table'. I put the fields manually into the report, compiled it and used it with my application. The report worked just like i expected. The only problem is when i try to read the fields. tks for the reply =)

should i give more info on the problem? anyone else having the same problem? thanks _o/

hi maanik777, try this : { SELECT random_name."FACULTY" AS ROOMALLOT_FACULTY, COUNT(*) AS ROOMALLOT_COUNT FROM ( SELECT DISTINCT ROOMALLOT."FACULTY", ROOMALLOT."RDATE", ROOMALLOT."SESS" FROM "MODULE4"."ROOMALLOT" ROOMALLOT ) random_name GROUP BY random_name."FACULTY" } hope that helps _o/

Using IReport 3.5.2, when i try to read fields from a query using the check box "Automatically retrieve fields" or pressing "Read Fields" button, i receive this message: "Error:null " Looking at IDE's Log file, i found this exception: java.lang.NullPointerException at com.jaspersoft.ireport.designer.data.ReportQueryDialog.recursiveInterpreter(ReportQueryDialog.java:1843) at com.jaspersoft.ireport.designer.data.ReportQueryDialog$FieldReader.run(ReportQueryDialog.java:546) The Database connection seems to be ok, I can preview the report using it. the full log file is attached. Is it a bug or i'm missing some configuration?