aspose file tools*
The moose likes JDBC and the fly likes Jasper Report returns no records when I add a date/time predicate to it. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Jasper Report returns no records when I add a date/time predicate to it." Watch "Jasper Report returns no records when I add a date/time predicate to it." New topic
Author

Jasper Report returns no records when I add a date/time predicate to it.

Jacky Luk
Ranch Hand

Joined: Aug 02, 2012
Posts: 601
When I add a $P{DateStart} and $P{DateEnd} constraint to the query.
There are no records returned back, But there actually should be.
When there are no constraints, the query behaves normally.



[Thumbnail for report error.png]

 
 
subject: Jasper Report returns no records when I add a date/time predicate to it.