SSRS – Force Proper Case

SSRS – Force Proper Case

Ever had to deal with someone who likes to store their title content in ALL CAPS… thereby mucking with your report formatting and general nonsense? This little ditty can be applied as an expression to Reporting Services to deal with it, additionally useful if you don’t want to do the work at the Stored procedure.

=StrConv(Fields!FieldName.Value, VbStrConv.ProperCase)

Keep in mind this is proper case (1st letter in each word is uppercase).


Australian. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf R. SQL Server Developer. Three sons. One daughter. Last Trip: New York.

Related Posts
Leave a comment

Your email address will not be published. Required fields are marked *