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).

Mike250

I'm an Australian Chief Analytics Officer passionate about data science, visual insights, and all things sport—particularly cricket. An adventurer at heart, I’ve gone from abseiling cliffs to snorkeling in crystal-clear waters, sleeping in the wilds of Africa, and exploring destinations worldwide, with my latest trip taking me to Bali. When I'm not diving into data or analytics, I'm spending time with my three sons and two daughters, attempting to hit sixes for my local cricket club, reviewing chicken schnitzels or honing my craft around a coffee machine.

Related Posts
Leave a comment

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