I have just created a report that is displayed as a dashboard through internet explorer and I am looking at setting it up to rollover to the next date at a specific time, but at this stage it is not happening. any help that could be past on would be great.

Please try setting the AutoRefresh property of the report. To set 1) In the properties window select report from the dropdown or click on blank area in the designer outside the report body. 2) Set the AutoRefresh property in number of seconds. When done so, the content of the report will be automatically refreshed. You mentioned that you need to rollover to the nextday at a specific time. If it is not with actual time but with a cutoff time, then you may have to set the expression in your report =iif(Hour(System.DateTime.Now)>18,DateAdd("d",1,System.DateTime.Today),System.DateTime.Today) as per above, the date would evalucated to the next day from 7pm (>18); it would show current date prior to 7 pm. hope this helps. please feel free to discuss if you need any further clarifications.Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi Bilal, thanks for your reply, in regards to getting the Dash board to rollover to the next date what we had to do was but it into a sub-report and that seemed to work but the expression that you outlined above was used for getting the time that we wanted it to change at. thanks for your time and I am sure I will have many more questions over the next few months... Cheers Cathy