Hide matrix columns on ssrs report

(0) Share

Report

Posted on by Hawra

786

Hi Everyone ..

I'm create matrix in SSRS report i want hide or show column based on an expression for example
i have 2 column one for Value and one for Amount.. I want hide value column when the value = amount
So, i try this expression ( iif(Fields!Amount.Value=Fields!Value.Value,"False","True") ) but it's not working it show me this error ..

This is my report

Please help me ..

Thank you..

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

your first mistake is to put " (comma) around true and fasle.

it should return true or false as Boolean value. you are trying to return a string.

Was this reply helpful? Yes No
Verified answer

Hawra 786 on at

Like (0)

Report

that is correct thank you Mt. Sohaib

Was this reply helpful? Yes No