Solved

SSRS hiding groups conditionally

Posted on 2010-11-22
9
1,063 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
 
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Pivot 7 46
SSRS 2012 Report building- Expressions 3 68
ssrs chart  summary and detail 2 34
SSRS Report Runtime Error 20 39
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 …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

707 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