Avatar of lcallah93
lcallah93
Flag for United States of America asked on

Crystal Server Report Instances

Hello experts -

I am looking for an easy way (famous last words, I know) to skip daily instances in Crystal Server 2008.  We have over 1,600 daily recurring instances and two nights ago a tech had to stop the CMS because a Crystal report locked all the database tables.  I have restarted the CMS, but now all the instances are running in chronological order, starting where it left off two nights ago.

UGH.

I would like to just stop all the pending instances for all recurring reports and have them start up fresh tonight but I don't see any way to do that easily.  I have tried to search the instance manager for pending reports but they are not listed as pending until they are queued up to run.  If I delete all the recurring instances then I will need to re-create all 1,600 recurring instances all over again.

Am I missing something?

Help!!

Lisa
Crystal Reports

Avatar of undefined
Last Comment
lcallah93

8/22/2022 - Mon
Mike McCracken

I don't think you are missing anything.

I am not aware of a way to do what you want.

mlmcc
ASKER CERTIFIED SOLUTION
LinInDenver

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
lcallah93

ASKER
That is a great idea with the ODBC connection.  I ended letting them run and all is well, but I will keep that in my toolbox (I have a feeling it will happen again....)

Thank you and happy new year!!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy