Help, I would like to number my Rank row in Cross Tab:
Rank | Student Name | AverageScore | Rownumber()
1. John Denis | 99 | 2
2. Mark Evans | 88 | 3
3. Clare | 78 | 1
I Sorted by AverageScore Column which is calculated by Total/Count GroupBy Student Name. I want to show user the ranking. But the =RowNumber() returns the default alphabet sequence number from database. Which function I could use to do the RANK column in CrossTab in Telerik reporting?
4 Answers, 1 is accepted
I noticed that you have opened a support ticket on the same topic. But please let me share my answer here as well:
"If I understood correctly the required layout, one of the columns should represent the Rank of the Student Name by its AverageScore. We do not offer out-of-the-box a user function that can rank aggregate values. It would be necessary to implement a custom aggregate function to achieve this requirement.
I have attached the assembly (CustomAggregates.dll) containing the aggregate function and the code of the aggregate (CustomAggregates solution). The report Report1.trdp utilizes the aggregate in the Rank column to calculate the ranks. Note that the equal values will be ranked equally.
The assembly should be copied in the Standalone Designer's folder and registered in its configuration file (Telerik.ReportDesigner.exe.config) - Extending Report Designer. The designer folder is placed in default Telerik Reporting installation folder, e.g. C:\Program Files (x86)\Progress\Telerik Reporting <VERSION>\Report Designer).
In this case the extension of the configuration should look as:
<!-- Add assembly references -->
The column "AverageScore" does the Ranking which is already existing in the CVS in your example. It is no way for me to pre-create that column in database. I am looking for a Rank which is a calculated Average Score, like [=Sum(Fields.ColumnB) > 0 ? Sum(Fields.ColumnA) / Sum(Fields.ColumnA) : 0]. The example (or the dll) doesn't work.
Another thought is that I am only looking for a SEQUENCE NUMBER based on a calculated column Sort By in a CrossTab. Is it possible to do in Telerik?
I've already answered to your question in the support thread (ID: 1364873) that you've opened on the same topic. Can we continue the discussion in one of both threads? So we can keep a better track on the exchanged information.
Telerik couldn't do a sequence number by out of the box after my 1 week's research?
There are a lot of areas Telerik could improve.