Solved

SSRS hiding groups conditionally

Posted on 2010-11-22
9
1,067 Views
Last Modified: 2012-05-10
Hello,

I would like to hide the group header if there are no detail rows associated with it. I have tried various things, filters, conditionally hiding the row, etc. but nothing seems to be working.

Any ideas?

Thanks.
0
Comment
Question by:erp1022
  • 4
  • 4
9 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 34193675
it depends on what you are grouping by. The wholereport is suppose to be based on the group of what you want and of the report.
If there is no group data then there should be no report.
0
 

Author Comment

by:erp1022
ID: 34196748
What do you mean "it depends on what you are grouping by"? I am grouping on a particular field in my dataset. I think you may have misunderstood my question. I want to see all transactions for a particular customer and am gouping by customer. If there are no transactions for that particular customer, it is still showing a line with the customer name.

So, as I stated in my original question: how to hide a group header if there are no detail rows for that group?
0
 
LVL 27

Expert Comment

by:planocz
ID: 34197583
Then you need something like this on the header row, hide visiblty properties box..
=IF Trim(Fields!customer.name=""), True, False)
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 27

Expert Comment

by:planocz
ID: 34197605
That is good for  whole customer, But for no data you would need to check a field that you have in your detail that could have no data..
=IF Trim(Fields!Product.name=""), True, False)
0
 

Author Comment

by:erp1022
ID: 34200344
Your solution is not working. I put an expression on my header row visibility:

=iif(Trim(Fields!SalesNumber.Value =""), True, False)  

Fields!SalesNumber.Value is a field from my detail line. It is still showing the blank lines with customer name when there is no detail.

Does anyone else know how to do this?
0
 
LVL 27

Expert Comment

by:planocz
ID: 34200620
I was thinking that you may have to do the same expression in the header and the detail row.
=iif(Trim(Fields!SalesNumber.Value =""), True, False)
0
 

Accepted Solution

by:
erp1022 earned 0 total points
ID: 34200831
Still not working.
0
 
LVL 4

Expert Comment

by:BostonMA
ID: 34239866
Let me see if I understand the problem.  The report groups by customer.  Your data set returns all customers even if they havent made a purchase. You want to filter out customers in your table who have not made a purchase?  If so add a filter to the table to say sum(purchases) > 0.  Then those customers without a purchase will be excluded from the report and you wont have any group headers without any data.

0
 

Author Closing Comment

by:erp1022
ID: 34276692
No one with knowledge of how to fix this issue responded to my post.
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

763 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