Row Visibility within reports

(0) Share

Report

Posted on by Community Member

Hello, How Can I write in Visual Studio to hide a row IF the a button on the Item Card is Ticked.

I have a button "Qa Inspection In" on the item card. If this is ticked my report it should display the row. If it is unticked the row should be hidden.

I'm thinking it's something along these lines..

==iif(Fields!Item_QaInspectionIn.Value, TRUE *Then Show, otherwise Hide*

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (4)

Verified answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

Hi

You can write the Visibility esxpression like below

=IIF(Fields!Item_QaInspectionIn.Value, FALSE,TRUE)

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

Did you try

==iif(Fields!Item_QaInspectionIn.Value, TRUE ,FALSE)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you both. How could I Adapt it to say if it's empty insert A text box in it's place saying like "Qa Inspection Not Required"

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

you need to add a new row add with text box and text required and visibility condition just like above

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you again, One last question.

I have a box which says "Signed:" which appears if the box is visible. How can I Change this text to say "QA NOT REQUIRED" If you imagine the box to not be visible.

To rephrase. If the button is ticked, Display what's currently existing. If the box is unticked Change the text to say "QA NOT REQUIRED".

Thanks

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (0)

Report

Hello,

See the bellow Image. In this scenario if button checked then Row will hide.

If you want show on button checked then just changes the order Like:

=IIF (Fields!ButtonTicked.Value,FALSE,TRUE)

Note: in image expression, it missed Fields!, so don't confused, write as upper.

__________

For BOX

If box is a textBox then you can write in TextBox expression like:

=IIF (Fields!ButtonTicked.Value,"Signed","QA Not Required")

IF Both Controls are different then put two controls in overlapped and write hidden expression as you want.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you that's very helpful!

Was this reply helpful? Yes No