Hi,
I am generating report using Telerik Reporting v13.0
But facing some issue with sorting Crosstab.
Please find attached screens, where I have grouped Crosstab by "City" and wanted Sorting by "Name" ASC but that is not working
Grouped by City - Philadelphia (that is working)
But under this Group all record should sort by name
- CUP
- Globant
- Cognizant
Expected order should be Cognizant then CUP and then Globant , but that is not working
Thank you!
Prashant
1 Answer, 1 is accepted
0
Accepted
Hello Prashant,
If you want to sort the Crosstab both by name and city, there are two options which are demonstrated in the attached report:
1) you can add Sortings to the data source of the Crosstab (demonstrated in the upper Crosstab). To do this mark the Crosstab -> from the properties grid -> Data -> Sortings (check the first screenshot). In this case, the data will be directly sorted and there is no need to set Sorting on the rows/columns of the Crosstab.
2) the second option is to set the Sorting by the name in the detail group. Check the second screenshot. In this way, the defined detail of the group will be sorted.
Regards,
Neli
Progress Telerik
If you want to sort the Crosstab both by name and city, there are two options which are demonstrated in the attached report:
1) you can add Sortings to the data source of the Crosstab (demonstrated in the upper Crosstab). To do this mark the Crosstab -> from the properties grid -> Data -> Sortings (check the first screenshot). In this case, the data will be directly sorted and there is no need to set Sorting on the rows/columns of the Crosstab.
2) the second option is to set the Sorting by the name in the detail group. Check the second screenshot. In this way, the defined detail of the group will be sorted.
Regards,
Neli
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items