SSRS : RDLC - NULL Check, Date Format and Concatenate of Fields

this blog discuss about the basic operation like how to concatenate two fields or NULL check or convert string into uppercase or format date/time field in rdlc .

Concatenate two Fields Value :  

We can simply concatenate two string field as below

Example:

 =Fields!Description.Value +"("+Fields!Code.Value+")"

NULL Check of Field Value:

We can use IS Nothing statement to check field NULL value.

Example:

 =iif(Fields!Letter.Value Is Nothing, “No Letter Found”,Fields!Letter.Value)

Date Format:

We can use FormatDateTime() function to format date/time field value.

Example:

=FormatDateTime(Fields!OrderDate.Value, DateFormat.ShortDate))

Options for Dateformat : 

• GeneralDate
• LongDate
• ShortDate
• LongTime
• ShortTime 

UpperCase of Field Value:

We can use  UCase() function to convert the string or character containing the specified string  into uppercase.

Exmaple :
=UCase(Fields!Description.Value)

Thanks For Visiting !!