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 second image shows the records in the Table report and the Full Name and Education columns are in uppercase.
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)
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 click the preview tab to see the Lowercase FullName and the Education fields. For more functions >> Click Here!
