Hiding multiple fields and labels based on field value

[Former Member]

I've got a report where I have a Company label and a field which brings back the company name when the report is run against a stored procedure.

In certain cases I will return the text "HIDDEN" for the company name data field in the report header. When this happens I basically want to hide the Company: label and data field (with the text "HIDDEN" in it) so that these two fields do not display on the report.

How can i do this most efficiently?

TIA

Harry

[Former Member]

Hi Harry,

Do this steps,

Right click on field>Fomat field>In the common tab> Check "Suppress" check box> Click on X-2(Formula editor) button.

In the formula editor,write like,

{DB.Field1}="Hidden"

Regards,

Salah

[Former Member]

Thank you so much Salah!

Harry