Hello,

I am creating matrix report , I want to hide the column in which Data Field is null. I did tried by writing this expression

=IIF(IsNothing((Fields!test_name.Value,

"matrix1_category")),true,false)

but problem with this expression is it hide the column on first page,It does not do it on rest of the pages, I have multiple pages grouped on one column and added page break on that group.

Please give me some solution

Column 1 -ChildGroup-> Column 2 -ChildGroup-> Coulmn 3  | Column 4 |

    | Data      |

Added Page Break on Column 1 and Column 2

Thank-you!

can you post screen shot of your current report. I cant make out structure from what you posted. Also specify what are the row groups and column groups used

Hi Piyush,

If I understand correctly, you want to hide the entire column, when it has NULL value of the specify field. We can configure the Column Visibility.

Please refer to the following steps:
1. Right click the column, select Column Visibility option.
2. Select Show or hide based on an expression with above expression.

If there are any misunderstanding, please feel free to let me know.

Regards,
Alisa Tang

Hi Piyush,

On column visibility, use expression to show/hide. Like below expression:

=Iif(Sum(Fields!Measure.Value) = 0, True, False)

Thanks, Madhu