Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
blank cell in report

Respondida blank cell in report

  • Tuesday, January 22, 2013 10:16 AM
     
     
    Sign In to Vote
    0

    Hello,
    A table is used in report.
    A number of cells are blank because the data is returned as null from the database.
    Is it possible to remove those blank cells from the report?
    Thanks

     

All Replies

  • Tuesday, January 22, 2013 4:22 PM
     
     Proposed
    Sign In to Vote
    0

    use Report builder

      According to your condition you can display the column.

       = iif(<field> is nothing,0,<field>)

      = iif(<field> is nothing,' ',<field>)

    • Proposed As Answer by Sachi_SG Tuesday, January 22, 2013 4:22 PM
    •  
     
  • Tuesday, January 22, 2013 7:57 PM
     
     Answered
    Sign In to Vote
    0

    Hi arkiboys,

    What i understand from your question is, you need to remove the null value rows in the dataset. If so, the best way to handle it is in your query to filter null values. If you can not do that, write expression on dataset filters.

    for example if you need to filter out all the rows having field_value as null, then write expression as

    = not IsNothing(Fields!field_value.Value)

    Type as boolean, operator as "=" and value as true. this will filter all null values to be displayed.