angeleam
asked on
Suppress rows
I want to pull all data but only display records where <field> number is greater than one. How do I suppress rows where the <field> is not greater than one.
ASKER
Thanks I was doing it backwards > 1. How do I suppress the group header to only show the group header name if there are details. It is printing the group name even if there are no details.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Right click the section in the left margin
Click SECTION EXPERT
Click the formula button to the right of SUPPRESS
{YourField} < 1
mlmcc