you could use a command object and do a select based on the time that the system reports when it is run...since it is being run at set times, just select.

Create a date-time parameter which can accept range values and is optional. Then create a formula which selects the data. The parameter can be used when you want to run ad-hoc reports for any given period. When you schedule your report on your Crystal Server, leave the date parameter blank. Since no parameter is entered the formula selects the default periods, depending on the current time.


If HasValue({?Date Parameter}) then
   // parameter has been entered
   {table.datefield} = {?Date Parameter}
else if CStr(CurrentDateTime, "HH:mm") >= "17:30"
   // time is 5:30pm or later, run noon to 5:30pm report
  {table.datefield} >= DateAdd("n", 720, CurrentDate) and
  {table.datefield} < DateAdd("n", 1050, CurrentDate)
else
   // 5:30pm yesterday to noon today
  {table.datefield} >= DateAdd("n", -390, CurrentDate) and
  {table.datefield} < DateAdd("n", 720, CurrentDate)


Then put your formula into the select expert:

{@FilterDate} [and ...]