Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1043
  • Last Modified:

SSRS, MSSQL 2008 - hiding/suppressing group header line if no detail

Hello,

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:

Customer Smith
     Item 1     10/22/10    245.00    
     Item 4     11/05/10    500.00
Customer Jones
     Item 20   10/01/10    750.00
     Item 14   09/15/10    800.00
Customer Doe
     etc.

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?

Thanks!
0
erp1022
Asked:
erp1022
  • 3
  • 2
1 Solution
 
BostonMACommented:
Put an expression on the visiblity of the table which depends on a count or sum of one of your data items.
0
 
erp1022Author Commented:
Still not working, see attachment.

Also, I had this question on another post, and then closed the question because it wasn't being answered properly. After I closed it, you responded with a fix regarding a filter. I tried the filter but that didn't work either.
Screen-shots.docx
0
 
BostonMACommented:
Okay...it wasnt clear from your question that you are using a tablix and not a table so that changes the solution.  

When you look at your dataset is the InvSale_Amount all null?  If so then the sum will not equal zero.  Here are a few options to try

=IsNothing(InvSal_Amount.Value)

=sum(IIF(IsNothing(InvSal_Amount.Value),0,InvSal_Amount.Value))

0
 
erp1022Author Commented:
More specific please. You gave me a couple of options above, but I have no idea where to put them. Is it an expression for group visibility? Row visibility? Or something else?
0
 
erp1022Author Commented:
Question closed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now