Tuesday, January 22, 2013 10:16 AM
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?
Tuesday, January 22, 2013 4:22 PM
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
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.