Wednesday, June 13, 2012

first letter Capital in the string of every word in Reporting Services (Camel case)

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

No comments:

Post a Comment