How do I show or hide a text field on my custom sales invoice report (via report extension) depending on a value of a certain field on the invoice.
How do I show or hide a text field on my custom sales invoice report (via report extension) depending on a value of a certain field on the invoice.
Hi jdrco,
You can go to that Text box Property in the report design layout, and check the visibility property and then go to expression icon and put the values like below.
=iif(First(Fields!Textbox.Value, "DataSet_Result")='Your value',false,true)
and then click ok button after putting above code.
Thanks.
Hi, If you are using RDLC, you can use the iif function below.
Visibility is true when a certain field is True.
In addition, if the field you mentioned is already in the DataItem, you don't need to use ReportExtension, you only need to modify the Layout file.
Hope this helps.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 285,407 Super User
Martin Dráb 225,446 Super User
nmaenpaa 101,148