Something we've noticed about the PivotGrid is that it treats different capitalization as different values in the result set. For example, if I have values of;
Bun Maker
Bun maker
bun maker
BUN MAKER
BuN mAkEr
...these will each be treated as different/unique values. Is there a way to ignore capitalization and treat all similarly-spelled entries as the same? We thought about applying standard spelling at source, but making everything upper or lower case doesn't look right.
Bun Maker
Bun maker
bun maker
BUN MAKER
BuN mAkEr
...these will each be treated as different/unique values. Is there a way to ignore capitalization and treat all similarly-spelled entries as the same? We thought about applying standard spelling at source, but making everything upper or lower case doesn't look right.
1 Answer, 1 is accepted
0
Hello Derek,
This is achievable by taking advantage of the custom grouping capabilities of the RadPivotGrid which are demonstrated in this online. By overriding the ToString and CompareTo methods you should be able to achieve the desired result.
Regards,
Angel Petrov
Telerik
This is achievable by taking advantage of the custom grouping capabilities of the RadPivotGrid which are demonstrated in this online. By overriding the ToString and CompareTo methods you should be able to achieve the desired result.
Regards,
Angel Petrov
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.