Apr 19

Ms Report Expression to hide data column if data doesn’t exist

In some cases data will not exist(ex:fax no may consist or may not consist in offices)at that time fax column will appear empty its looks odd in your report so we have to hide the fax column by using the below expression:

[code language=”csharp”]

IIF(First(Fields!FAX.Value, "Info_TBL_CLIENTMASTER") Is Nothing,".",","+System.Environment.NewLine +"FAX :"+ Format(First(Fields!FAX.Value, "Info_TBL_CLIENTMASTER"))+".")


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>