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.
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.
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.