PROPER Function in SSRS 2008

SSRS does not contain an inbuilt method for making the first letter of each word uppercase. we can write  uppercase(left(field,1)) + lowercase(right(field,len(string)-1) to do the same job but it gets over complicated and it only modifies first letter of a multi word string. We can use the following function to convert string to proper case.

StrConv(Fields!Description.Value,vbProperCase)

Note: vbProperCase is an inbuilt VB method in SSRS and you don’t need to define it in the RDL file.

3 thoughts on “PROPER Function in SSRS 2008

Add yours

  1. Greetings from Colorado! I’m bored to death at work so I decided to browse your blog on my
    iphone during lunch break. I really like the knowledge you provide here and
    can’t wait to take a look when I get home. I’m shocked at
    how fast your blog loaded on my phone .. I’m
    not even using WIFI, just 3G .. Anyways, superb blog!

Leave a comment

Create a website or blog at WordPress.com

Up ↑