SSRS LCase Function

The SSRS LCase function is a Text function that converts the uppercase character in a given field into a lowercase string. This article explains how to use the LCase function to convert a string to lowercase characters with an example.

The syntax of the SSRS LCase function for converting text or string to lowercase characters is as shown below.


To demonstrate the LCase function, we use the Employee table below, which has 15 records grouped by Occupation. The image shows the records in the Table report.

Source Table

SSRS LCase function – Lowercase Example

For this, let me add a new column to the right side of the FullName column. Next, right-click the textbox under the LCase 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 lowercase character conversion. The SSRS LCase function below will convert the uppercase characters in a FulName column to lowercase and return a new string.

SSRS LCase Function expression to convert the string to Lowercase

Please click the preview tab to see the Lowercase FullName field. For more functions >> Click Here!

SSRS LCase Function to convert the characters to lowercase report preview

Let me create one more new column to the right of the Education column. Next, right-click the textbox under LCase Education to write the expression below. Here, the LCase function converts the uppercase characters from the Education column to a lowercase string.


Please check the report preview.

SSRS LCase Function to convert the uppercase characters to lowercase string preview