must be missing the obvious ...

[dogfuel]

Trying to use the JasperServer calendar prompt with a MySql database. I have tried using a second string prompt in my query with no prompt for it and a default of:

 

Code:

new SimpleDateFormat("yyyy-MM-dd"«»).format($P{JavaDteFrom})

 

My report displays with "no data ..." in both iReport and through JasperServer.

 

Am I missing something obvious?

 

Thanks!

[csbac]

Hi!

Put a field onto the report that displays the value of the parameter; then, you can check whether the query should return any data with this value.

 

Also, it might be a good idea to use java.util.Date, not String, for the parameter type, and default values such as

new java.util.Date()

new java.util.Date(0)

new java.util.Date(new java.util.Date()-30l*24*3600*1000)

(one month back, take care of the "l" (L) after 30)

 

Hope this helps,

Sebastian

 

PS: Added a *1000, as those are msecs.

Post edited by: csbac, at: 2007/09/11 16:31