SSRS conditionally hide group header
Hello,
I have a report and I am grouping by customer. The detail lines show transaction date, amount, etc. of things that customer bought from us. I have a date parameter in my report, so if the customer didn't buy anything that month (or whatever the date
range is), my report still shows a line with just the customer name. I would like to suppress that customer if no detail.
I have tried setting the visibility expression on the row itself and on the group. My expression uses a field from the detail line: =iif(Fields!TranNumber.Value = "", True, False). I have also tried using IsNothing before the field name. Nothing works. Anyone
have any ideas?
Thanks.
November 23rd, 2010 4:03pm
IF You mean when you don't have data for particular date than you just get column header. and you want to avoid that,
you can set Table or Tablix visibility property.
Try something like
=IIF (IsNothing(SUM(Fields!TranNumber.Value, "Yourdataset"), True, False)
Inset ed of hiding header just hide the table, anyways you don't have any data..right??Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 4:50pm
Hi,
Please try setting the expression for the row visibility on the row where you display the group header. The steps are
1. Right click on the row where customer name is printed
2. select row visibility
3. click on 'show or hide based on expression'
4. click on expression button and enter the below
=iif(count(Fields!TranNumber.Value,"Customer")=0,true,false)
Note : In the above expression, replace the "Customer" with the name of the customer group.
Hope this helps.
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
BH
November 23rd, 2010 11:52pm