SSRS UCase Function

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

The syntax of the SSRS UCase function for converting text or strings to upper-case characters is shown below.


To demonstrate the UCase 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 UCase function – Uppercase Example

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

SSRS UCase Function expression to convert the string to uppercase

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


Please click the preview tab to see the Uppercase Name and the Education field. For more functions >> Click Here!

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