alex.gomes.sis

Hello, everybody! I hava a database where the fields are named like name_field. In iReport i have to do my querys like this: SELECT t.nameField AS nameField FROM Table t[/code]But in JasperReport Studio i have to do this to work: SELECT t.name_field AS nameField FROM Table t[/code]I have a lot of projects that pass parameters with querys using the method of iReport, there's a way to change it in JasperReport Studio? Thanks!

Thanks for the answer Massimo! For now i'll use iReport, since this functionality is very important to me. Again, thank you very much! Best regards for you too.

Hello llona! I followed your instructions and the button is still disabled, i've made the configuration again just to be sure and nothing changed. When i use a dataProvider with SQL the button works just fine. By the way, thank you very much for the attention!

Hello guys! I've made a dataAdapter for an Hibernate connection, when i click in the Test button a successful message appears to me, but when i go to the Query Editor and select my dataAdapter, the Read Fields button stays disabled, this way i'm unable to read my querys and obtain my fields! Thanks in advance for everyone!

I solved it by placing the following jars in the directory "Jaspersoft Studio-5.5.0.finalfeaturesjre.win32.win32.x86_64.feature_1.7.0.u25jrelibext" slf4j-log4j12-1.6.1.jar; hibernate-commons-annotations-4.0.2.Final.jar; hibernate3.jar; commons-collections-3.1.jar; jta-1.1.jar; slf4j-api-1.6.1.jar; log4j-1.2.15.jar; antlr-2.7.7.jar; dom4j-1.6.1.jar; hibernate-jpa-2.0-api-1.0.1.Final.jar; javassist-3.18.1-GA.jar; jboss-logging-3.1.0.GA.jar; jboss-transaction-api_1.1_spec-1.0.1.Final.jar With this, the connection was successful, my problem now is that the button "Read Fields" in the Query Editor is disabled, i'm trying to solve it now.