Hi,
I have a table (SQL server) in which all data are upper case only. How can I use an expression to present the data in a good format in the report?
I have a public shared VB function: properCase(sentence as string) that I was hoping to use in a way something like this:
"=MyglobalClass.properCase(Fields.CompanyTitle)", but it is not possible.
Is there a way to accomplish proper title casing using the functions available in the expressions dialoge?
Kai
Hello Kai,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. I have been looking into it and I can suggest you use Expression for the binding of the Columns. You can use the string’s ToLower method in order to format the values. Here you can find more information:
http://help.infragistics.com/Help/Doc/Reporting/2014.1/CLR4.0/HTML/How_to_Use_Expressions.html
Feel free to write me if you have further questions.
I am just checking if you got this worked out or you still require any assistance or clarification on the matter.