Reporting Services Text File

Question

Is there a way in Reporting Services to control the case of text when rendering a report.

Data in the database have

RANDOM CAPS Blends

and in the reports that they would like to see

Random cap mixes

Answer 1

Such an expression should do the trick:

=UCase(left(Fields!Name.Value, 1)) + strconv(Mid(Fields!Name.Value, 2), vbLowerCase)

Answer 2

Perhaps you can use an expression for this, I just don't know if the function is available from the box to make changes in the case. You can get a list of all string functions in the expression window.

If there is no such function, you can use the built-in code to do the trick.