Expression to show or hide Tool box in report design

Finance and Operations/AX Developer Forum
1

Hi All,
I have created a Taxinvoice report and in the design I want to show the consignee(YesNo) details. When Consinee is yes in Salesorder header than only I want to show the consignee details otherwise it should show blank .I am using below expression in ConsigneeName(Tool Box) in the design.

=iif(First(Fields!ConsigneeName.Value, “Dataset1”) = “1”, True, False)

Consignee1

image

It is not throwing any error while deploying the report
it is working fine when consignee is “YES” but when we selected “NO” it is not working properly it is not showing any data but instead of showing blank page it is showing the label of Consinee
image

please guide me
Thankyou in Advance.

2

Try this, syntax

= IIF(Fields!ConsigneeName.Value = 1, False, True)

1 Like