Link to home
Start Free TrialLog in
Avatar of cehrnow
cehrnow

asked on

Suppress Individual Records

Is it possible to suppress display of individual records based on a formula calculated for each record ?
Avatar of Mike McCracken
Mike McCracken

Sure.

You can suppress the full section through the Section Expert

Right click the section in the left hand margin
Click SECTION EXPERT
Click the FORMULA BUTTON to the right of SUPPRESS
     Enter a formula that is TRUE when you want to suppress
     {SomeField} = 0

Click OK
Click OK

Do you need the records for summaries or totals in the report?
If not why not try to filter them before the report?

mlmcc
If the formula can be expressed as a VIEW, then the answer is probably "Yes." If it can't be, then can you give a little more detail on just what you need to accomplish?

Tom
Avatar of cehrnow

ASKER

Each record displayed also shows a formula value of True or False. Need to only display those records with a value of True. Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cehrnow

ASKER

You're right - thanks.