Crystal Reports boolean criteria causes (7520) error

Yahoo Archive
1
Problem solved.

I added 2 formulas as follows:

{@Closed}
if {JobHead.JobClosed} = True then 1 else 0

{@Scheduled}
if {JobHead.CheckOff4} = True then 1 else 0

Then I changed the selection criteria to :

{@Closed} = 0.00 and
{@Scheduled} = 0.00

Now the report runs fine on the client computer.

Allen


--- In vantage@yahoogroups.com, "apt876sp1" <atucker@...> wrote:
>
> I have a report which selects jobs to be scheduled using 2 simple criteria.
> not Jobclosed and
> not Checkoff4
>
> It runs fine on my machine but users get an error.
> "Column not found/specified (7520)" Sql server error.
>
> Any suggestions on how to make the report run on a client computer?
>
> Allen Tucker
> IT Manager
> Espey Mfg. & Electronics Corp.
> Email: atucker@...
>
2
I have a report which selects jobs to be scheduled using 2 simple criteria.
not Jobclosed and
not Checkoff4

It runs fine on my machine but users get an error.
"Column not found/specified (7520)" Sql server error.

Any suggestions on how to make the report run on a client computer?

Allen Tucker
IT Manager
Espey Mfg. & Electronics Corp.
Email: atucker@...
3
What kind of connection does the report use?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
apt876sp1
Sent: Monday, April 06, 2009 9:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports boolean criteria causes (7520) error



I have a report which selects jobs to be scheduled using 2 simple criteria.
not Jobclosed and
not Checkoff4

It runs fine on my machine but users get an error.
"Column not found/specified (7520)" Sql server error.

Any suggestions on how to make the report run on a client computer?

Allen Tucker
IT Manager
Espey Mfg. & Electronics Corp.
Email: atucker@espey. <mailto:atucker%40espey.com> com





[Non-text portions of this message have been removed]
4
ODBC connection

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> What kind of connection does the report use?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> apt876sp1
> Sent: Monday, April 06, 2009 9:02 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reports boolean criteria causes (7520) error
>
>
>
> I have a report which selects jobs to be scheduled using 2 simple criteria.
> not Jobclosed and
> not Checkoff4
>
> It runs fine on my machine but users get an error.
> "Column not found/specified (7520)" Sql server error.
>
> Any suggestions on how to make the report run on a client computer?
>
> Allen Tucker
> IT Manager
> Espey Mfg. & Electronics Corp.
> Email: atucker@espey. <mailto:atucker%40espey.com> com
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Make sure the ODBC On the users PC is setup Exactly like the ODBC on yours.



Screen Shot yours and make the fields look exactly the same.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
apt876sp1
Sent: Monday, April 06, 2009 9:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports boolean criteria causes (7520) error



ODBC connection

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...> wrote:
>
> What kind of connection does the report use?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> apt876sp1
> Sent: Monday, April 06, 2009 9:02 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Crystal Reports boolean criteria causes (7520) error
>
>
>
> I have a report which selects jobs to be scheduled using 2 simple
criteria.
> not Jobclosed and
> not Checkoff4
>
> It runs fine on my machine but users get an error.
> "Column not found/specified (7520)" Sql server error.
>
> Any suggestions on how to make the report run on a client computer?
>
> Allen Tucker
> IT Manager
> Espey Mfg. & Electronics Corp.
> Email: atucker@espey. <mailto:atucker%40espey.com> com
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]