I don't know if this is a bug, but the grouping of the cross-tab seems to be case-sensitive.
Is it possible to ignore case sensitivity for grouping in the crosstab ?
For example: currently product "ABC" and "ABc" are being groupped as different products!
What I'd like to have is for the cross-tab to ignore the CASE and group "ABC" and "ABc" together.
PS: yes it can be done within the SQL query, but I don't want to put load on the SQL server since quantity of data is large.