Reporting Services Text Case

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

开发者_如何学运维

The data in the database has a

RANDOM mixtures of CAPS

and on the reports they would like to see

Random mixtures of caps

---

An expression like this should do the trick:

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

---

You might be able to use an expression for this, I just don't know if there's an out of the box function available to perform changes to the case. You can get a list of all string functions in the expression window.

If there is no such function, you can still use embedded code to do the trick.