Answer 2
Sure. You could do this in VB or SQL. Here's a quick exmaple of doing this using a VB function. Open the Report Properties dialog and paste this code into the Code window:
Function ProperCase(InputString as String) As String
Dim i as Integer
If InputString <> "" Then
Mid(InputString , 1, 1) = UCase(Mid(InputString , 1, 1))
For i = 1 To Len(InputString) - 1
If Mid(InputString, i, 2) = Chr(13) + Chr(10) Then
Mid(InputString, i + 2, 1) = UCase(Mid(InputString, i + 2, 1))
End If
If Mid(InputString, i, 1) = " " Then
Mid(InputString, i + 1, 1) = UCase(Mid(InputString, i + 1, 1))
End If
Next
Return InputString
End If
End Function
In a textbox, right-click. Choose Expression... and type:
=Code.ProperCase("the cow jumped over the moon.")
If you want to apply this logic to a field, enter:
=Code.ProperCase(Fields!SomeFieldName.Value)
Preview the report.
I hope this is helpful.
Paul Turley [Hitachi Consulting] SQLServerBIBlog.com