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

Rank Number in CrossTab

4 Answers 101 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Gordon
Top achievements
Rank 1
Gordon asked on 10 Dec 2018, 07:01 PM

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?

Thanks

4 Answers, 1 is accepted

Sort by
0
Silviya
Telerik team
answered on 12 Dec 2018, 11:46 AM
Hello Gordon,

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 -->
<Telerik.Reporting>
    <AssemblyReferences>
        <add name="CustomAggregates" version="1.0.0.0" />
    </AssemblyReferences>
</Telerik.Reporting>
"

Regards,
Silviya
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
0
Gordon
Top achievements
Rank 1
answered on 17 Dec 2018, 04:11 PM

Hi Silviya,

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?

Thanks

 

 

 

0
Silviya
Telerik team
answered on 18 Dec 2018, 02:05 PM
Hi,

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.

Regards,
Silviya
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
0
Gordon
Top achievements
Rank 1
answered on 18 Dec 2018, 02:20 PM

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.

Tags
General Discussions
Asked by
Gordon
Top achievements
Rank 1
Answers by
Silviya
Telerik team
Gordon
Top achievements
Rank 1
Share this question
or