Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report Automation Post Reply Post New Topic
Author Message
qtz1906
Newbie
Newbie


Joined: 05 Aug 2011
Online Status: Offline
Posts: 6
Quote qtz1906 Replybullet Topic: Report Automation
     Posted: 05 Aug 2011 at 8:36am
I have a report setup to run every 2 hours in Crystal 2008. However I don't want it ran all times throughout the night, how can I set a cut off time for each day?
 
Thanks for the assistance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 05 Aug 2011 at 9:06am
if your deployment system does not allow for managing this one possible trick is to still let it run but to add extra item in select statement to return 0 rows during the non desired times
example to include data from 8 am to 5 pm
currenttime in time(8,0,0) to time(17,0,0)


Edited by DBlank - 05 Aug 2011 at 9:06am
IP IP Logged
qtz1906
Newbie
Newbie


Joined: 05 Aug 2011
Online Status: Offline
Posts: 6
Quote qtz1906 Replybullet Posted: 08 Aug 2011 at 7:25am
Ok thanks. I will try that.
IP IP Logged
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