How can I suppress  a page header based on a field value from a record

Posted on 2012-09-11
Last Modified: 2012-09-11
I need to display a message on Page header, but that message will only needs be displayed if out of all the records there is atleast one record in detail section whose flag field value is set to true.
Please Experts help me.

Question by:NoorFaz
    LVL 100

    Accepted Solution

    Try this idea

    Add a formula to the report
    Name - HasATrue
    If {YourField} = TRUE then

    SUppress using
         Sum({@HasATrue}) >= 1


    Author Comment

    already tried it but for some reason since its page header, its not getting suppressed. I need to know this value before report is printed.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    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…

    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

    22 Experts available now in Live!

    Get 1:1 Help Now