Solved

SSRS hiding groups conditionally

Posted on 2010-11-22
9
1,065 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…

831 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