Date and Time Issue..

[swapna_gelle]

I created report in jasper studio. Issue is my report need to run  example  10/1/2017 7:00:00 am to 10/2/2017 7:00:000 am means pull data today and next 24 hours data.

I failed to display with this time format..

How can i run the report with specifi dat and time format conditions in the report?

 

Any help ???

 

Thanks.

[bsvorinic]

You need to be more specific.

If the question is how to get data for specific period and you are using SQL to retrieve data for report you should use parameters to define WHERE condition inside SQL. My approach is to prepare and test SQL outside Jasper Studio using SQL Developer or similar tool and then use tested SQL inside report.

If the problem is formating and displaying timestamp, then you can use PATTERN property of the TEXT field to format data the way you want, or use Java inside EXPRESSION property to format output (for example "new SimpleDateFormat("dd.MM.yyyy").format($F{DATUM}").

Regards,

Bruno