Object_Visibility

[nyzja]

I have a Crystal Report that runs fine in production, but gives me the following error when I run it against the test server:

Error in formula <Object_Visibility>.
'
'
This field name is not known.

The test server is an exact copy of the production, I've had it restored from production a few times already.

Anybody have an idea about my problem?


Thanks!

 

[Durango122]

fi
check your datasource and make sure it's pointing to the right one and make sure to test database is up to date


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[nyzja]

I checked the datasource and it's correct. I also verified the dtabase and it is up to date. Error is still there.

 

[dgillz]

How about posting the formula?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[nyzja]

The thing is I'm not even sure what formula it's talking about. The report itself has a store procedure as it's source... The stored procedure runs fine on SQL server. It starts out like this....



CREATE procedure spInv
@de varchar(20),
@bi varchar(20),
@cA bit = 0

as
begin

SET NOCOUNT ON

declare @idnum varchar(10),
@seqn int,
@demoCond varchar(2000),
@billCond varchar(2000),
@strSQL varchar(4000)

 

[dgillz]

When crystal errors out, it typically shows you the offending formula and the cursor itself should be where the offending field is in your case.

If it is doing this, please post the formula.

If it is not doing this, please confirm that you are running the report inside crystal reports itself and not from inside another application.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown