[#2573] - iReport MySQL-Query with date parameters got wrong records

Category:
Bug report
Priority:
Normal
Status:
New
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

At the report query designer i have got wrong data:

 

I have build three  Parameters with datatypes:

my_util_Date   (java.util.date)  The default value expression is 2012/9/19

my_sqltimestamp_Date (java.sql.Timestamp)  The default value expression is 2012/9/19

my_sqldatetime_Date (java.sql.Time)  The default value expression is 2012-9-19

 

In my query i use this parameter at the where clause

... where ([tablename].[db_date] >= $P!{myDate});  myDate = my_util_Date, my_sqltimestamp_Date and my_sqldateteime_Date

I have tested the three parameters one after the other

 

All three Result Preview Data results  starts with records from 2011

 

What' going wrong!   I'm not familar with JAVA or iReport.

 

Thanks for your work

 

Best regards.

 

v4.8.0
hans-peter.wunderlich's picture
Joined: Oct 31 2012 - 12:31am
Last seen: 11 months 2 weeks ago
Feedback