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

Wednesday, June 6, 2012

how to Display Group Footer in Last page?

Hi,
Today while working , i got problem that "our client want Group Footer should display only in display". After doing lot of R&D   i found the solution.
For Group footer Write following Hidden/Supress expression :
 =IIF(Last(Fields!Field Name.Value,"GroupName")=Last(Fields!Fields Name.Value,"Dataset Name),False,True)

If you execute, you notice that group summation will appear only last page. this is because of above hidden or suppress expression.