File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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: 590
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]

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Jasper Report returns no records when I add a date/time predicate to it.