Print Page | Close Window

scheduling reports outside of weekends

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16976
Printed Date: 03 May 2025 at 4:31pm


Topic: scheduling reports outside of weekends
Posted By: db3712
Subject: scheduling reports outside of weekends
Date Posted: 06 Jul 2012 at 9:20am
Hi,
I need to schedule a report to run every 3 hours Monday through Friday.  It appears, through Crystal Management Console that I can scheduled the report every 3 hours but I don't see an option to exclude weekends.  Is there an alternative?
 
Thanks!


Replies:
Posted By: hilfy
Date Posted: 06 Jul 2012 at 11:26am
The only alternative is to set up multiple schedules, one for each hour the report is supposed to run.  You'll configure these to run weekly and then select the days that they will run (all weekdays).
 
Once you have one set up, you can "reschedule" that one, changing the time for each.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: db3712
Date Posted: 09 Jul 2012 at 5:34am
Thank you for your idea.  Appreciate it.

Posted By: DBlank
Date Posted: 10 Jul 2012 at 4:10am
not sure it applies here as i do not use CMC but rather an add on tool for some scheduled reports using Windows scheduled jobs, but just in case it helps...
I add in extra crystal select statement options to compensate for hourly reports taht I only want tro run on certain days. This makes the report return no values so it technically runs but does not get sent out because it has 0 results.
For weekday only reports I use:
weekday(currentdate) in [2,3,4,5,6]


Print Page | Close Window