SSRS StrConv Function

The SSRS StrConv function is a Text function that will convert the given string field or expression to the specified one, such as converting a string to lowercase or uppercase. The syntax of the StrConv function to perform the string conversion is shown below.

=StrConv(Fields!ProductDescription.Value, vbProperCase)

To demonstrate the SSRS StrConv function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.

Source Table

SSRS StrConv function Example

For this, let me add a new column to the right side of the FirstName column. Next, right-click the textbox under the StrConv First Name and choose the Expression. To understand the report, I suggest you refer to the articles on charts, tables, grouping, and format tables in SSRS.

Choose the expression option

It opens the following expression window to perform string conversation. The below SSRS StrConv function will convert the First Name string field to the uppercase.

=StrConv(Fields!FirstName.Value, vbUpperCase)
SSRS StrConv Function for string conversion

Similarly, let me create one more new column to the right of the LastName. Here, we use the vbLowerCase as the second argument of the StrConv string function, which converts the last name rows to lowercase.

=StrConv(Fields!LastName.Value, vbLowerCase)

Please click the preview tab to see the report with upper & lower strings. For more text functions >> Click Here!

SSRS StrConv Function for string conversion to lower and upper case