Not answered Crosstab report ordering of rows

Hi Telerik Team,

Hello Russell,

The order of the rows in a Table (Crosstab/List) is defined by the order of the TableGroups in the RowGroups hierarchy. For example if you have 2 row groups defined at the 1st level of the RowGroups hierarchy to, say, group by City and group by Year, you will have all cities at the first place, followed by all years.

To order the members in a group (ex. to order the cities in the City group in alphabetic order) you have to specify some sorting criteria the TableGroup.Sorting collection.

If you want to order the data at the database level you should use exactly the same criteria, as you use for the grouping. Otherwise the reporting engine will scramble the data according to the groups it will calculate.
 

All the best,
Svetoslav
the Telerik team

Hi;
I'm trying to do the following with crosstab:

Class A                        Subject A        Subject B        Subject C        Total
            Student A        85                85                90                260
            Student B        70                75                85                230

Where students for each class are sorted against their total score (Descending) i.e. Top performer First.

Can you please guide me on how to do this.
PS. My database is that complex that this cannot be done without crosstab (like with normal table with groups).

Thanks

Hi Nad Lewis,

Yes, you may sort on a total expression in the appropriate group ( In this case: =Sum(Fields.Score) )

Please find attached two predefined solutions for achieving your task.

Best wishes,
Milen
the Telerik team