any crystal folks? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

any crystal folks?

Author

Topic

jhermiz

3564 Posts

Posted - 2004-03-04 : 14:43:10

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 ?

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?

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

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-03-04 : 16:17:49

I've seen Crystal do some crazy stuff, but not anything like that.
After you make the change, did you do a "Verify Database?" Try that and see if that works.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

jhermiz

3564 Posts

Posted - 2004-03-04 : 16:30:38

err i hate crystal.

i recreated the report and it works now...

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-03-04 : 16:52:19

That was going to be my next suggestion. I've gotten away fro Crystal and I'm using Active Reports.Net. It has it's problems, but I've not really run into very many of them. With Crystal, I'm constantly running into weird problems like this.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources