[How add a parameter to a Xlm Adapter]

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 

[Why Preview differs from PDF so much ???]

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

[URGENT : Jasper Report Server installation fails everytime]

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 ?  

[URGENT : Jasper Report Server installation fails everytime]

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

[PHPJasperXML sample1.php, goes blank and nothing happens]

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

[Is it possible to use a $P{xxxxx} parameter for a complete query string]

OK Thanks !!

[Is it possible to use a $P{xxxxx} parameter for a complete query string]

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

[Subreport : overlapped lines]

Thanks for the hints but I still have the same problem.

Attached the jrxml files and the pdf of report error

Thanks

Giovannino

[Subreport : overlapped lines]

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

[Conditional expression]

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