Crystal Reports formula to suppress zero

dave_sky
dave_sky used Ask the Experts™
on
Using Visual Studio 2005 crystal reports.

I have 2 suppress zero formulas in a crystal reports form that I need combined:

Right({TblBasicPlumbingBidDetail.ItemNumber},1) = ">"
Right({TblBasicPlumbingBidDetail.Description},1) = ")"

The formulas work ok individually.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You don't say what the combined rule has to do.

For the field that you are trying to format, if both of these  have to be true you just put the word AND between the two expressions.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
If only 1 has to be true use OR

mlmcc

Author

Commented:
>You don't say what the combined rule has to do.

If the user's text in field "ItemNumber" contains">" then field "FixtureUpgradePrice" suppress zero.
If the user's text in field "Description" contains")" then field "FixtureUpgradePrice" suppress zero.

I tried this and there is no error, but neither formula works
Right({TblBasicPlumbingBidDetail.ItemNumber},1) = ">"
AND Right({TblBasicPlumbingBidDetail.Description},1) = ")"

Author

Commented:
Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial