apellew
asked on
Changes to a formula not being saved on exit ...
Hi there
I'm having a problem with saving a formula in Crystal 10 (service pack 4). On opening the report I get "the saved data will be discarded since one or more formulas failed to compile". If I open the report and run it, I get to the offending formula
if IsNull ({REPORTDATA.DIARY_VERSION
then 0
else if {TRDC.DIARY_VERSION} > 0 or
{TRDC.DIARY_VERSION} = 0
then -2
else 0
Replacing TRDC with REPORTDATA and I then Save and Close. Then I log on to the database, run the report which successfully runs. Then I close and save, or save, or save as new file. But whatever I do, when I reopen the report the formula is still wrong - I cannot get Crystal to save the report.
Am I missing something?
I'm having a problem with saving a formula in Crystal 10 (service pack 4). On opening the report I get "the saved data will be discarded since one or more formulas failed to compile". If I open the report and run it, I get to the offending formula
if IsNull ({REPORTDATA.DIARY_VERSION
then 0
else if {TRDC.DIARY_VERSION} > 0 or
{TRDC.DIARY_VERSION} = 0
then -2
else 0
Replacing TRDC with REPORTDATA and I then Save and Close. Then I log on to the database, run the report which successfully runs. Then I close and save, or save, or save as new file. But whatever I do, when I reopen the report the formula is still wrong - I cannot get Crystal to save the report.
Am I missing something?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The problem is that I'm opening the report, seeing the error, fixing it then running the report to make sure it works. Saving it, shutting down crystal, re-opening crystal and loading it and seeing exactly the same error as if nothing had changed.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wykabryan >
Yes, we've changed the alias from TRDC to REPORTDATA. It (REPORTDATA) is being used consistently throughout the report except for this one formula which is showing the error.
Spykair >
Sorry but we need that checked as the report will actually be run by the End-USers from our User Application (written in DElphi, using the Crystal 10 vcl) and the VCL errors if the report does not have any data with it. At the moment though we're seeing problems in the designer so havn't got that far yet!
Yes, we've changed the alias from TRDC to REPORTDATA. It (REPORTDATA) is being used consistently throughout the report except for this one formula which is showing the error.
Spykair >
Sorry but we need that checked as the report will actually be run by the End-USers from our User Application (written in DElphi, using the Crystal 10 vcl) and the VCL errors if the report does not have any data with it. At the moment though we're seeing problems in the designer so havn't got that far yet!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No, actually that's exactly what it should be and what I change it too ... but it doesn't seem to save correctly (i.e. when I re-open the report the error is still there and the changes I've made are discarded).
I've had some other problems with Crystal 10 (relating to Oracle databases) and was wondering if this is a problem that is widely know.
I'll run a verify database (as soon as I've installed Oracle 10g locally on my machine ... long story).
Cheers!
I've had some other problems with Crystal 10 (relating to Oracle databases) and was wondering if this is a problem that is widely know.
I'll run a verify database (as soon as I've installed Oracle 10g locally on my machine ... long story).
Cheers!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have split the points for this question to everyone who helped ... all the things mentioned were good to check, but it looks like the problem is more likly due to the way we are using Crystal (embedded in a Delphi client, calling Oracle 9i2 stored procedures via a Oracle 8 connector, etc). In short; thanks everyone, I've got a lot of things to look at now!
Glad I could help.
Spykair
Spykair
ASKER