giovannino

Hi all, I did a report based on a xml adapter and it produces the report of ALL records like using a Select * from table. I wonder if it's possible to add a kind of parameter or a filter in order to ask to user , when run the report, the ID number of record he likes to print . I can't use the direct DB suorce connection becouse I don't know how tables are structured and also no possible for security reasons. Many thanks Gio

Hi, I'm stucked because I don't understand why there is a big different on bottom space and right side space between Preview and PDF. I checked everything possible Please have a look to attachment Thanks

HI , thanks for reply, I got my SQL under WAMP and I prefer it for sure than install also Postgress. It seems to me that installation don't ask for database in general but only for Postgress... Do you think that is possible to install Jasper Report Server using mySQL instead of Progress ?

Hello all, I've downloaded the jasperreports-server-cp-6.4.0 and tried to install it almost 5 times without success. I got a 64 bit notebook with W10 installed. I run the installer exe everytime as administrator and at the end of installation process I got always the same error message. I'm really stucked and frustated . It's seems impossible that such popular sw has still installation issues. Thanks Gio

HI , I got the same problem . Did you fix it ? Could you post a solution of your problem ? Thanks

OK Thanks !!

Hi all, I'm wondering if it's possible to use only a parameter like $P{pdf_query} to pass a complete query from php program. For istance "SELECT * FROM TABLE XXXXX". Or parameter can only be use to pass a variable of a select yet recorded on Ireport I've tried but I got this error. net.sf.jasperreports.engine.JRException: Error executing SQL statement for : data at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:152) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:464) at com.jaspersoft.studio.data.reader.DatasetReader.start(DatasetReader.java:184) at com.jaspersoft.studio.property.dataset.dialog.DataPreviewTable$4.run(DataPreviewTable.java:250) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) ... 9 more

Thanks for the hints but I still have the same problem. Attached the jrxml files and the pdf of report error Thanks Giovannino

Dear all, I'm using JasperReport 3.6.1 and I've a problem using subreport within a master report. The subreport have different lines and I don't know before to run the report how many lines it will have. I created and inserted a new subreport but lines overlap laber of next one topic. I defined position fix from the top and resize in comparison to the top object . Could you please suggest me the trick ?? Thanks . Giovannino

Dear all, I'm trying to use this expression within a image espression field but it doesn't work. It gives me always the ON image. $F{APPUNTAMENTO_FLAGESEG} is a number not null field (oracle XE) I would like to see a radio box OFF icon or ON if value of $F{APPUNTAMENTO_FLAGESEG} is 0 or different (1). (($F{APPUNTAMENTO_FLAGESEG} == "0") ? "C:\\Programmi\\jasperserver-3.0\\iReport-nb-3.6.1\\GC_Reports\\radio_button_off.jpg" : "C:\\Programmi\\jasperserver-3.0\\iReport-nb-3.6.1\\GC_Reports\\radio_button_on.jpg") Many thanks Giovannino