Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS hiding groups conditionally

Posted on 2010-11-22
9
Medium Priority
?
1,072 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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

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…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

580 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