this message...is no good!

[jhermiz2]

Everytime I open this one report I have I get

"The Saved Data Will Be Discarded Since One or more formulas failed to compile."

But I compiled all my formulas with NO errors...

I need to get rid of this message.

Jon

 

[IdoMillet]

You may have a problem in a format or suppress expression for a section or an object in the report.

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[jhermiz2]

wow...

so how do i fix this...

i noticed something as well...everytime i try to open the report..i get that message above..then when i hit the lightning bolt the icon at the top I get:

This field name is not known

It takes me to the formula editor where the code is:

if IsNull ({TBLEMPLOYEE.LABORCODE})
then 0
else if {dbo_TBLEMPLOYEE.LABORCODE} <> "CON"
then -3
else if {dbo_TBLEMPLOYEE.LABORCODE} = "CON"
then -2
else 0

Well I fix it and get rid of the dbo_ to

if IsNull ({TBLEMPLOYEE.LABORCODE})
then 0
else if {TBLEMPLOYEE.LABORCODE} <> "CON"
then -3
else if {TBLEMPLOYEE.LABORCODE} = "CON"
then -2
else 0

Then I compile that it says No errors..

Then I save it...the report runs. I save the ENTIRE report. I then close the report and reopen it...and its the same damn problem. On the left side of the container of the Formula Workshop it shows a folder:

Error This field name is not known.
X+1 Group #2 Order

but I dont have a field order or a group #2 order...what the heck is going on ?

 

[jhermiz2]

Forgot to mention even after I save it and reopen the code CHANGES back to:

if IsNull ({TBLEMPLOYEE.LABORCODE})
then 0
else if {dbo_TBLEMPLOYEE.LABORCODE} <> "CON"
then -3
else if {dbo_TBLEMPLOYEE.LABORCODE} = "CON"
then -2
else 0


...

I dont even have a GROUP called Order that is what is confusing me. Anyone please know what is causing this mess?

 

[jhermiz2]

I decided to record the problem.

Can anyone check out this link please I would be most greatful.

http://www.jakrauseinc.com/jhermiz/problem.avi

Thanks,
Jon

 

[jhermiz2]

nevermind i recreated it.

jon

 

[synapsevampire]

You might want to try a Database->Verify Database, or if it was a basic report and version 8.5, save as a CR 7 and then try to open it.

-k