Solved

Suppress Individual Records

Posted on 2012-03-28
5
353 Views
Last Modified: 2012-03-29
Is it possible to suppress display of individual records based on a formula calculated for each record ?
0
Comment
Question by:cehrnow
  • 2
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
 
LVL 27

Expert Comment

by:tliotta
Comment Utility
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
 

Author Comment

by:cehrnow
Comment Utility
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:cehrnow
Comment Utility
You're right - thanks.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now