Parameter problem in User defined report

[Ajile]

Hi. Wonder if anyone can help with this. I have a user who has created a very simple report based on the timestamp field. He has created two parameters based on start time and end time. These are based on the Date/Time field. He would like the report to run from 6am to 2pm.

However, when he enters the new dates and refreshes the data, he only receives data from 2am to 5.45am. If he enters the dates manually into the SQL query, the report runs with no issues.

What should the parameters be in order that the report runs purely on the insertion of the new date. Please help.

Many Thanks
Ajile.

 

[alam]

Make sure to attache the parameter field to concerned timestamp column in Selection Criteria and i think it should work fine..., also in ur case it appears as in selection criteria u might have assighned the parameters between END Date and START Date unlike Start Date and End Date...so jus go to SELECTION CRITERIA and check it...Hope it will solve ur problem..

Best of Luck..