Hi,

i have created a report which contains an XRPivotGrid. The rows field of the data contains data similar to:

Group 1

Group 2

Group 3

etc...

Group 10

Group 11

Sorting should be just like i posted above, and that is how the data is sorted in the dataset i use as dataprovider. However the rows field in the grid resorts it by itself. Only thing i can achieve is doing it ascending or descending. Which gets me the below result.

Group 1

Group 10

Group 11

Group 2

Group 3

etc...

The PivotGridControl is similar to this control, but not in the reports  toolbox, but in the win toolbox. This pivot has a CustomFieldSort event, in which i can specify how to sort the rows field. But how do i do a similar custom sorting for the control in the reports toolbox? Or is there another way to solve this? Thanks in advance!