Jasper Report is taking too much time to generate the report

[srija kamidi]

Hi,

My report is running slow It is taking 15 minutes to run for 1 hour time period , When I ran it in Database it is taking less than a min.

Number of records are 1172.

I have checked the jasper log query also It is not taking much time when I ran it in DB by passing the parameters.

&

If I give hardcoded date time parameters in the query it is giving results with in a minute.

Can someone please help me with this.

 

Thanks in advance!