conditionally hiding groups in SQL Reporting Services 2008

Posted on 2011-05-04
Medium Priority
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

Accepted Solution

cojdev earned 2000 total points
ID: 35690805
specify the field you want or fields you want to check.

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

612 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