Share
ReportHow 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.
You’re offline. This is a read only version of the page.
479
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
#1
André Arnaud de Cal...
291,820
Super User 2024 Season 2
#2
Martin Dráb
230,514
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
