SSRS, MSSQL 2008 - hiding/suppressing group header line if no detail
Posted on 2010-11-30
I have an SRS report that shows customers and the things they bought from us. My report is grouped on Customer and then the detail lines are an item they bought from us (the item number), date, amount, etc. So it would look like this:
Item 1 10/22/10 245.00
Item 4 11/05/10 500.00
Item 20 10/01/10 750.00
Item 14 09/15/10 800.00
My end users can select a date range when they run this report. If the customer hasn't bought anything within the date range, the line with their name (group header record) is still showing up and I would like to suppress that. I have tried conditionally hiding the row visibility and the group visibility based on a detail field, but that is not working. Any ideas?