Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: scheduling reports outside of weekends Post Reply Post New Topic
Author Message
db3712
Groupie
Groupie
Avatar

Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Quote db3712 Replybullet Topic: scheduling reports outside of weekends
    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!


Edited by db3712 - 06 Jul 2012 at 10:37am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
db3712
Groupie
Groupie
Avatar

Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Quote db3712 Replybullet Posted: 09 Jul 2012 at 5:34am
Thank you for your idea.  Appreciate it.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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]
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.025 seconds.