Crystal Question - Job Traveler

Yahoo Archive
1
Look at the format of the Jobasmbl.ASMSEQ field. It is a string with
4 characters, the first 3 being spaces. (at least in version 5.0)
Try if {jobasmbl.ASMSEQ} > ' 0'
> then crSilver
> else crNoColor

HTH,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, Jim Selinger <jim@k...> wrote:
> Have any you ever tried this or are doing this:
>
> With your job traveler - Job assembly - if it is not 0, having
Crystal color
> in the background, silver.
>
> I am trying to make this change, because our employees have trouble
> recognizing the assembly not being 0 (zero).
>
> What I did is simple. I went in to the jobasmbl.ASMSEQ field, right
> clicked, clicked on format and went to the border tab. There I set
up a
> formula to display a silver background if the assembly # is greater
than 0
> (zero). The formula is as follows:
>
> if {jobasmbl.ASMSEQ} > '0'
> then crSilver
> else crNoColor
>
> The funny thing here is it does not work. I feel it is right.
Where did I
> go wrong? Please help.
>
> Jim Selinger
> Kocsis Bros. Machine Co.
> 11755 S. Austin Avenue / 4321 Railroad Avenue
> Alsip, IL 60803 / East Chicago, IN 46312
>
> Phone: (708) 597-8110
> Fax: (708) 389-0792
2
Have any you ever tried this or are doing this:

With your job traveler - Job assembly - if it is not 0, having Crystal color
in the background, silver.

I am trying to make this change, because our employees have trouble
recognizing the assembly not being 0 (zero).

What I did is simple. I went in to the jobasmbl.ASMSEQ field, right
clicked, clicked on format and went to the border tab. There I set up a
formula to display a silver background if the assembly # is greater than 0
(zero). The formula is as follows:

if {jobasmbl.ASMSEQ} > '0'
then crSilver
else crNoColor

The funny thing here is it does not work. I feel it is right. Where did I
go wrong? Please help.

Jim Selinger
Kocsis Bros. Machine Co.
11755 S. Austin Avenue / 4321 Railroad Avenue
Alsip, IL 60803 / East Chicago, IN 46312

Phone: (708) 597-8110
Fax: (708) 389-0792
3
If have something similar with a price field... I went to the background
tab of the field and changed it... here is the code I used:



IF {Fieldname} <=0 Then RED ELSE BLACK



Seems to work fine for what I need to ...this was using Crystal Reports
8.5



Brandon R Murch

Director of Information Technology

WindStone Medical Inc.

(406)259.6387

bmurch@...



-----Original Message-----
From: Jim Selinger [mailto:jim@...]
Sent: Friday, September 19, 2003 12:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Question - Job Traveler
Importance: High



Have any you ever tried this or are doing this:

With your job traveler - Job assembly - if it is not 0, having Crystal
color
in the background, silver.

I am trying to make this change, because our employees have trouble
recognizing the assembly not being 0 (zero).

What I did is simple. I went in to the jobasmbl.ASMSEQ field, right
clicked, clicked on format and went to the border tab. There I set up a
formula to display a silver background if the assembly # is greater than
0
(zero). The formula is as follows:

if {jobasmbl.ASMSEQ} > '0'
then crSilver
else crNoColor

The funny thing here is it does not work. I feel it is right. Where
did I
go wrong? Please help.

Jim Selinger
Kocsis Bros. Machine Co.
11755 S. Austin Avenue / 4321 Railroad Avenue
Alsip, IL 60803 / East Chicago, IN 46312

Phone: (708) 597-8110
Fax: (708) 389-0792






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=194081.3897168.5135684.1261774/D=egroupweb/S=1705
007183:HM/A=1732163/R=0/SIG=11n0nglqg/*http:/www.ediets.com/start.cfm?co
de=30510&media=zone> click here



<http://us.adserver.yahoo.com/l?M=194081.3897168.5135684.1261774/D=egrou
pmail/S=:HM/A=1732163/rand=791226233>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



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