Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Looking for a 3rd-party schedule for Crystal 9

Status
Not open for further replies.

kkinnea

Programmer
Sep 30, 2002
25
US
Is there a good, workable 3rd-party scheduler for Crystal 9 yet? I tried looking at Report Scheduler from ReCrystallize as well as Christian Steven Software Scheduler but neither one worked or worked well.

Thanks,
Kristen
 
Kristen,

I've added version 9.0 compatibility to my Visual CUT software about a month ago. Feedback from customers, with one exception described below, is that the transition to the new version of Visual CUT (and new 9.0 runtime components) was problem-free.

An interesting discovery was that Crystal 9.0 (and hence the new runtime components used in Visual CUT), is more strict in checking formulas. One customer ran into a situtaion where one 8.5 report (out of many) that scheduled fine under the previous version of Visual CUT, didn't schedule under the new version. It turned out that when trying to open that report in 9.0, Crystal was complaining about a badly written formula (that Crystal 8.5 was not complaining about). After fixing that formula, all was well.

Let me know if you want to test Visual CUT. It would be nice to get a post from you on this forum comparing the various schedulers you have tested.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Ido,

I would be interested in knowing the formula that processed in 8.x but failed in 9. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
Hi Ken,

This thread is from 4 months ago!

I don't remember what the problem was exactly, but it was related to an IF THEN ELSE situation (I think mismatched data types that 8.5 wasn't catching for some odd reason). Once I opened it in Crystal 9 it was very obvious where the problem was so if you run into a similar situation, you would have no problem in troubleshooting it.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
I've upgraded my report scheduler cViewMANAGER to Cr9 a few months ago. Check that out as well.

But like Ido, I've found that later versions calculate formulas differently. My client had a CR7 report that crashed when running under CR8.5 run time.

The formula I had was to calculate the first of the month 6 months ago, so used

If month(CurrentDate) <7 then
Date(year(currentdate)-1, month(currentdate) + 6, 1)
else
Date(year(currentdate), month(currentdate) - 6, 1)

It looks like CR calculates both clauses and the later run time found an invalid date when run in January.

I changed the formula to...
numbervar y:=year(currentdate);
numbervar m:=month(currentdate);

If m <7 then
(y:=y-1;m:= + 6)
else
m:=m - 6;
Date(y,m,1)

And this works for all versions.
Editor and Publisher of Crystal Clear
 
Hello all,

Thank you for your replies and I apologize for taking so long to get to them!

Our group is using TechScheduler along with a back-end processing piece that one of the other developers wrote.

Kristen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top