erp1022
asked on
SSRS hiding groups conditionally
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.
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.
ASKER
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?
So, as I stated in my original question: how to hide a group header if there are no detail rows for that group?
Then you need something like this on the header row, hide visiblty properties box..
=IF Trim(Fields!customer.name= ""), True, False)
=IF Trim(Fields!customer.name=
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)
=IF Trim(Fields!Product.name="
ASKER
Your solution is not working. I put an expression on my header row visibility:
=iif(Trim(Fields!SalesNumb er.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?
=iif(Trim(Fields!SalesNumb
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?
I was thinking that you may have to do the same expression in the header and the detail row.
=iif(Trim(Fields!SalesNumb er.Value =""), True, False)
=iif(Trim(Fields!SalesNumb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
No one with knowledge of how to fix this issue responded to my post.
If there is no group data then there should be no report.