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