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.
=LCase(Fields!Name.Value)
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.
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.
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.
=LCase(Fields!FullName.Value)
Please click the preview tab to see the Lowercase FullName field. For more functions >> Click Here!
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.
=LCase(Fields!Edu.Value)
Please check the report preview.
