Need the ability to Capitalize the first letter of a string within SSRS? I found a gem of an SSRS function by Paul Turley of SolidQ.
From SSRS Report Properties switch to the Code tab and enter the following custom function:
Function ProperCase(InputString as String) As String
Dim i as Integer
If InputString <> “” Then
Mid(InputString , 1, 1) = UCase(Mid(InputString , 1, 1))
For i = 1 To Len(InputString) – 1
If Mid(InputString, i, 2) = Chr(13) + Chr(10) Then
Mid(InputString, i + 2, 1) = UCase(Mid(InputString, i + 2, 1))
End If
If Mid(InputString, i, 1) = ” ” Then
Mid(InputString, i + 1, 1) = UCase(Mid(InputString, i + 1, 1))
End If
Next
Return InputString
End If
End FunctionNow within your Reporting Services field expression, add:
=Code.ProperCase(LCase(Fields!field_name.Value))Works a treat in SSRS 2008. Good luck!
Regards for helping out, good information.