Crystal calc

Yahoo Archive
1
If your intent is not to display the field if it equals zero. You might try
to format the field, select the number tab, select customize button, select
suppress if zero.

Hope this is what you were looking for.

Dan Shallbetter
States Electric. Mfg.

-----Original Message-----
From: Wendy Bowen [mailto:wpursche@...]
Sent: Tuesday, June 25, 2002 1:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] crystal calc


Hi everyone!

I don't remember how I set up this calculation to work. I want this
calculation to display the "shift pay" if it is greater than 0. Otherwise,
display nothing. This is my calculation so far. I'm not sure how to set it
up so it will not display anything if the case is false.

IIF ({PRChkDtl.ShiftPay} > 0,{PRChkDtl.ShiftPay}, InStr
({PRChkDtl.ShiftPay},'' ))

Thanks!


Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

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


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
<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
<http://groups.yahoo.com/group/vantage/links>

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




[Non-text portions of this message have been removed]
2
Hi everyone!

I don't remember how I set up this calculation to work. I want this calculation to display the "shift pay" if it is greater than 0. Otherwise, display nothing. This is my calculation so far. I'm not sure how to set it up so it will not display anything if the case is false.

IIF ({PRChkDtl.ShiftPay} > 0,{PRChkDtl.ShiftPay}, InStr ({PRChkDtl.ShiftPay},'' ))

Thanks!


Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[Non-text portions of this message have been removed]
3
Hi Wendy,
You can't display "nothing" with a number, it will always print a ZERO if there is no value. So to display "nothing", you will have to use strings in your formula.

You could use the Crystal format in a formula like this:

If {PRChkDtl.ShiftPay} > 0 then totext({PRChkDtl.ShiftPay})
else ""

Unfortunately, with converting numbers to strings you lose the ability to easily format decimal places, dollar signs, etc. without a lot of other string manipulations.

Troy Funte
Liberty Electronics


----- Original Message -----
From: Wendy Bowen
To: vantage@yahoogroups.com
Sent: Tuesday, June 25, 2002 11:25 AM
Subject: [Vantage] crystal calc


Hi everyone!

I don't remember how I set up this calculation to work. I want this calculation to display the "shift pay" if it is greater than 0. Otherwise, display nothing. This is my calculation so far. I'm not sure how to set it up so it will not display anything if the case is false.

IIF ({PRChkDtl.ShiftPay} > 0,{PRChkDtl.ShiftPay}, InStr ({PRChkDtl.ShiftPay},'' ))

Thanks!


Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

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


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/.
(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! Terms of Service.


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