AK777 Posted September 19, 2017 Share Posted September 19, 2017 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now