This is a migrated thread and some comments may be shown as answers.

Crosstab - Grouping and Sorting

1 Answer 251 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Prashant
Top achievements
Rank 1
Prashant asked on 10 Apr 2019, 01:13 PM

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

Sort by
0
Accepted
Neli
Telerik team
answered on 15 Apr 2019, 09:30 AM
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
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
Tags
General Discussions
Asked by
Prashant
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or