Prashant16
Prashant16

Reputation: 1526

Make textobject bold based on condition in crystal report

In my crystal report, there are two columns Name and Amount. What i want is if Amount is blank then Name must be bold otherwise it will be in regular font. I don't know how to write formula for this condition. any help would be appreciated. Thanks.

Upvotes: -1

Views: 6879

Answers (3)

Danish Khan
Danish Khan

Reputation: 1

if ({DatabaseField.Column1}="Your Text") then
    crBold
else if({DatabaseField.Column1}="Your Text") then
    crBold
else
    crRegular

Upvotes: 0

Siva
Siva

Reputation: 9101

Try this

if Isnull(<<Databsefield Amount>>)
then crBold
Else crRegular

Upvotes: 1

Grant Winney
Grant Winney

Reputation: 66499

You should be able to:

  • Right-click the "Name" field
  • Select "Format Object"
  • Click the formula button next to "Style"

If your Amount field is a number (probably is, but you used the phrase "is blank"), then compare it to 0 instead of an empty string.

enter image description here

Upvotes: 3

Related Questions