Jump to content
Changes to the Jaspersoft community edition download ×

SQL Error suberports executing

2005 IR Help

Recommended Posts

By: goskar - goskar

SQL Error suberports executing

2004-11-28 10:20



i have got this SQL Statement in my subreport:




WHERE istleistung.kv_code= $P{kv_code} AND istleistung.vo_code=$P{vo_code} AND mitarbeiter.ma_code = istleistung.ma_code AND ISTLEISTUNG.IL_DATUM >= TO_DATE($P!{VONDATUM,,'%d,%m,%Y'}) AND ISTLEISTUNG.IL_DATUM < TO_DATE($P!{BISDATUM,,'%d,%m,%Y'}) GROUP BY mitarbeiter.ma_nname, mitarbeiter.ma_code

ORDER BY mitarbeiter.ma_nname, mitarbeiter.ma_code



I declared kv_code and vo_code as parameters and also declared it as <subreportParameter>.


In my SQL Statement this parameters are null and this error is written:


java.sql.SQLException: An illegal floating point number has been found in the statement.


Or maybe someone knows how i can interpret

@VO_CODE@ from SQL ( i wrote it as $P!{VO_CODE}


Thank you in advance,


Gosia R






By: Teodor Danciu - teodord

RE: SQL Error suberports executing

2004-11-30 03:56




The $!P{} syntax only supports a single report

parameter name inside the {} characters.


What exactly do you mean by:








Thank you,


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...