Search This Blog

Friday, 23 November 2012

ProperCase in SSRS

Probably, we all have used UpperCase/LowerCase text formatting by using UCase/LCase method in SSRS. But if we have to use ProperCase then SSRS does not give any direct method for this.
To use ProperCase in SSRS, we need to use following expression syntax:
=Microsoft.VisualBasic.StrConv(<Text Expression>,Microsoft.VisualBasic.VbStrConv.ProperCase)

For example, following expression
=Microsoft.VisualBasic.StrConv("this is a propercase example.",Microsoft.VisualBasic.VbStrConv.ProperCase)
Will give the output as
This Is A Propercase Example.