Cross-Tab grouping can't ignore CASE sensitivity [BUG]?

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.

Thanks

AK777's picture
88
Joined: Sep 7 2017 - 7:43am
Last seen: 6 years 13 hours ago

0 Answers:

No answers yet
Feedback