Link to home
Create AccountLog in
Crystal Reports

Crystal Reports

--

Questions

--

Followers

Top Experts

Avatar of David Svedarsky
David Svedarsky🇺🇸

Crystal Reports formula to suppress zero
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

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of peter57rpeter57r🇬🇧

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.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCrackenMike McCracken

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of David SvedarskyDavid Svedarsky🇺🇸

ASKER

>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) = ")"
Avatar of David SvedarskyDavid Svedarsky🇺🇸

ASKER

Thank you!
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Crystal Reports

Crystal Reports

--

Questions

--

Followers

Top Experts

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.