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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 580
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]

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Jasper Report returns no records when I add a date/time predicate to it.
 
Similar Threads
URLyBird: Just started, have a few questions
B&S double locking
how to get committed values from database in structs
Multi-row insert
URLyBird 1.2.1 - SecurityException