Case insensitive Grouping

[Charlie]

I have created a report that gets processed at run time (there's almost nothing in the designer).
We allow our users to configure how data is grouped in the report (fieldText is the name of a column in the DataTable the report is bound to).
The trouble is, I get separate groups for "Washington" and "washington".
Is there a way to have that Grouping be case insensitive?
Thank you.


Here is the code:

string expr = string.Format("Fields.{0}", fieldText);

myGroup.Groupings.AddRange(new Telerik.Reporting.Grouping[]
{
    new Telerik.Reporting.Grouping(expr))
});

[Elian]

Hello Charlie,

Instead of using "=Fields.FieldName", you can use "=ToLower(Fields.FieldName)". For more complicated cases when there isn't a built-in expression function, you can always use your own custom function, that will return the grouping criteria. 
 
Regards,
Elian
the Telerik team