Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to get rid of empty group column in SSRS using matrix?

Proposed Answer How to get rid of empty group column in SSRS using matrix?

  • Friday, February 08, 2013 3:05 AM
     
     
    Sign In to Vote
    0

    I need to get rid of the empty cell displayed of a group column as shown below. This happens if all rows in that column contains nothing or zero. I already put the necessary conditions like for instance IIF(SUM(Fields!Sales.Value) = Nothing OR SUM(Fields!Sales.Value) = 0, 0.0, SUM(Fields!Sales.value)) but to no avail.

    As seen in the columns, it doesn't display 0 but a blank white spaces.


     

All Replies

  • Friday, February 08, 2013 9:47 PM
     
     
    Sign In to Vote
    0
    try: =IIf(IsNothing(SUM(Fields!Sales.Value)),0,SUM(Fields!Sales.Value))

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

     
  • Monday, February 11, 2013 10:53 AM
     
     
    Sign In to Vote
    0
    It doesn't work as well.
     
  • Monday, February 11, 2013 11:21 AM
     
     Proposed Answer
    Sign In to Vote
    0

    i see you AX subtotal shows 0.0 in green. So do you have an expression in the visibility part maybe? if not

    can you try:

     =SUM(iif(IsNothing(Fields!Sales.Value),0,FIelds!Sales.Value))

    Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

    k r o o t z

     
  • Thursday, February 14, 2013 9:39 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Jayvee,

    Did you specify any expression to format the Textbox which display the total values? Please post a screent shot of the report design for further analysis.

    Regards,

    Fanny Liu

    Fanny Liu
    TechNet Community Support