Today I found a very good function in reporting services, which Converts the first
letter of every word in string to uppercase.
Either Sql server or Reporting Services does not provide any straight forward way to implement the same, we need to write the any user defined function to make the proper case.
But using "strConv" function we can simply achieve.
Here is the syntax:
=StrConv(Fields!Name.Value, vbProperCase)
or
=StrConv(Fields!Name.Value,3)
Converts the first letter of every word in string to uppercase.
To get more details, click on :
http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.strings.strconv.aspx
Either Sql server or Reporting Services does not provide any straight forward way to implement the same, we need to write the any user defined function to make the proper case.
But using "strConv" function we can simply achieve.
Here is the syntax:
=StrConv(Fields!Name.Value, vbProperCase)
or
=StrConv(Fields!Name.Value,3)
Converts the first letter of every word in string to uppercase.
To get more details, click on :
http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.strings.strconv.aspx