Hello,I need to create schedule, based on day of week and time.Here is requirement for schedule: Report should run each business day at 08:00 A.M and return data for: ProcessStartTime (some data item) BETWEEN MON run - data from prior FRI 04:00 P.M. and today MON, 08:00 A.M. TUE run - data from prior MON 04:00 P.M. and today TUE, 08:00 A.M....

Neeraj Shukla

• Apr 5th, 2013

Create a radio button on the report and set its value Sch, create a filter on the report and set it like that

case when dayofweek is monday then (somedate between (currentdate-2 day)+8:00:00 and current date 4 hrs)
else somedate between (currentdate-1 Day)+8:00:00 and current date + 4 hrs)
end

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• Jul 23rd, 2011

Since you want data for last one week so put condition on the report to fetch data only for last week.

While creating schedule you can click check boxes for the required days.

let me know if you need any help.

Answer Question  Select Best Answer