CODEWITHSUNDEEP
asp.netvb.netcrystal-reports-2008
Danbo
Danbo

Reputation: 31

How to suppress section in crystal report based on a condition in formula field

I have a formula for the conversion of the catcher type in the crystal report:

select {command.catcher_type}
case 1:'Bag Net'
case 2:'Beach/Drag Seine'
case 3:'Danish Seine'
case 4:'Gill Net'
case 5:'Handline'
case 6:'Longline'
case 7:'Paaling/Drive-in Net'
case 8:'Push Net'
case 9:'Ring Net'
case 10:'Round Haul Seine'
case 11:'Sardine/Mackerel/Scad Purse Siene'
case 12:'Trawl'
case 13:'Tuna Purse Seine'
case 14:{command.other_gear}
default: 'N/A'

this works in my report..

I have to suppress the section3 of my report depending on the value from the result of the formula above..

here is my formula for the suppression:

if('@gear_translate')="13" then
    True
else
    false

it doesn't work .. it did not suppressed the section3.

Upvotes: 1

Views: 8343

Answers (1)

Siva
Siva

Reputation: 9101

Result of the formula is a text filed and hence your target formula should be:

if {@gear_translate}="Tuna Purse Seine" then
    True
else
    false

Upvotes: 1

Related Questions