conditionally hiding groups in SQL Reporting Services 2008

Posted on 2011-05-04
Last Modified: 2012-05-11

I want to hide a group in SQL Reporting Services 2008, if there is no data for it.  The report is run based on a date range.

I have right-clicked on the group in the Row Groups section, but I do not know what formula to give it in the "Visibilty" section.  I want to simply say if there is no data for the group, then do not print data for it.

I have tried ="", =''., IsNull, Is Null, etc.  No dice.

Question by:apitech
    1 Comment
    LVL 2

    Accepted Solution

    specify the field you want or fields you want to check.

    =iif(Field1.Value=true ,false, true)

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now