Suppress Individual Records

Is it possible to suppress display of individual records based on a formula calculated for each record ?
cehrnowAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
The formula goes in the suppression formula not on the report itself.

DId you follow the instructions?

Right click the Section you want suppressed inthe left margin
Click SECTION EXPERT
Clickt eh FORMULA BUTTON to the right of SUPPRESS
Enter the formula here


mlmcc
0
 
mlmccCommented:
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
0
 
tliottaCommented:
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
0
 
cehrnowAuthor Commented:
Each record displayed also shows a formula value of True or False. Need to only display those records with a value of True. Thanks.
0
 
cehrnowAuthor Commented:
You're right - thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.