cehrnow
asked on
Suppress Individual Records
Is it possible to suppress display of individual records based on a formula calculated for each record ?
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
Tom
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You're right - thanks.
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