Suppress rows

Posted on 2008-11-19
Last Modified: 2012-05-05
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.
Question by:angeleam
    LVL 100

    Expert Comment

    Use conditional suppression

    Right click the section in the left margin
    Click the formula button to the right of SUPPRESS
    {YourField} < 1


    Author Comment

    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.
    LVL 100

    Accepted Solution

    Something like

    Count({SomeField},{Groupield} = 0


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    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. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 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