I have a report written with Crystal version 8.5 Developer Edition. Two of
our clients have upgraded the Crystal 9.0 and their reports are no longer
working at all. Since we didn't have version 9.0, I've downloaded the
30-day eval to try to duplicate their problems, and I have duplicated those
problems.

First, I had to download SP 2 as I was also getting the "no rowset returned"
error, but now I get very strange results.

The version of Pervasive Btrieve we're using is 6.15 (Win 95/NT) which is no
longer supported by Pervasive, but is still mentioned in Crystal's various
KB articles.

Btrieve stores tables in separate files. They have one set of data
dictionary files (file.ddf, field.ddf, index.ddf, etc.) which define the
tables, fields, and indices. It also points to the location of each table.
Because our users can have multiple sets of data for multiple companies, we
store the data dictionaries in one folder, and the data in other folders.
In previous versions of CR, this was not a problem, as we could dynamically
change the table locations (and filenames) in the data dictionaries to point
to the company they wished to report. Apparently in CR 9 this is no longer
possible.

For example, the data dictionary is in:

F:\DASIRUN\DATA\DDF\PA\FILE.DDF

The data tables are:

F:\DASIRUN\DATA\327\PAD010.327
F:\DASIRUN\DATA\327\PAD100.327

There seems to be no way to correctly set the table locations through "Set
Locations" inside CR 9, and when you attempt to run a report, it states that
it cannot locate table:

"F:\DASIRUN\DDF\PA\F:\DASIRUN\DATA\327\PAD010.327"

In an effort to "trick" this into working, I set the data file location
inside the data dictionary to:

"\..\..\DATA\327\PAD010.327" figuring it would create:

"F:\DASIRUN\DDF\PA\..\..\DATA\327\PAD010.327" but this simply seems to cause
CR 9 to hang.

CR 9 seems to hang with every attempt I've taken so far. Following various
KB articles, I looked under Set Database Location to change the location,
and the article is written specifically for Btrieve databases, but the text
makes no sense. It says to look for entries that do not exist. The only
place you can set a location is under the properties node of the FILE.DDF
itself, there are no location settings for the various tables. It also has
nodes under that properties node that have two settings for the FILE.DDF
setting, and one for another location that is set to "F:\DASIRUN\DATA\327\;"
(note the semicolon at the end). Attempting to change this particular
setting via hitting F2 (as the KB article states) hangs the system. I
should mention that this is being done on an XP machine.

Does ANYONE have any clues on this?

Crystal, in their infinite wisdom, made certain to denote when I downloaded
their eval that there would be NO technical support for the evaluation. I
guess they really want me to upgrade.

--
Fris "Hello, Crystal Sales Prevention Department, Lola speaking" bee® MCNGP
#13

http://www.mcngp.tk
The MCNGP Team - We're here to help

http://groups.yahoo.com/group/certaholics
Certaholics - We're here if you're beyond help

On Tue, 4 Nov 2003 12:43:34 -0500, =?iso-8859-1?Q?Frisbee=AE_MCNGP?=
<oncebitten (AT) twiceshy (DOT) com> wrote:

I know that this is no help with your problem, but BusinessVision Software
(accounting package) who use Pervasive for their backend and Crystal for all of
their reports, have advised that Crystal v 9.0 will not work with their product.
They are apparently in consultation with Seagate but have not made any progress
to date.

Tell your clients to stay away from Crystal 9.

Lyle

lurban (AT) nowhere (DOT) zz wrote:
Lyle, you've helped quite a bit. I'm at the point where I think I'm going
to have to make the same suggestion to my clients. I wonder if Crystal will
allow them to "downgrade" to version 8.5?

--
Fris "For a fee, of course" bee® MCNGP #13

http://www.mcngp.tk
The MCNGP Team - We're here to help

http://groups.yahoo.com/group/certaholics
Certaholics - We're here if you're beyond help

Crystal licensing has changed drastically. You need to have at least
Professional Edition to access Pervasive data. Your Eval will most
likely be Standard Edition, which is why you have "missing entries".

On Tue, 4 Nov 2003 12:43:34 -0500, Frisbee® MCNGP
<oncebitten (AT) twiceshy (DOT) com> wrote:


Gordon Bos
Q-RY Solutions
+31-(0)15-2564035

http://www.q-ry.nl/

Gordon wrote:
Appreciate the feedback, but I had downloaded the Enterprise Developer eval
version, which was the only version for eval I could even find on the site.
I thought there'd be a Pro version but couldn't find it.

As it turns out, it appears that there's at least one other accounting
software developer that is having the exact same problems and are working
with Crystal Decisions to rectify the problem, but in the mean time are
telling their clients to not upgrade to 9.0 at this time. We took the same
resolve, and the two clients of ours who had upgraded are returning 9.0.

--
Fris "CD can take their time, now" bee® MCNGP #13

http://www.mcngp.tk
The MCNGP Team - We're here to help

http://groups.yahoo.com/group/certaholics
Certaholics - We're here if you're beyond help