Rank Number in CrossTab

5 posts, 0 answers
  1. Gordon
    Gordon avatar
    5 posts
    Member since:
    Dec 2018

    Posted 10 Dec 2018 Link to this post

    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

  2. Silviya
    Admin
    Silviya avatar
    422 posts

    Posted 12 Dec 2018 Link to this post

    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
  3. Gordon
    Gordon avatar
    5 posts
    Member since:
    Dec 2018

    Posted 17 Dec 2018 in reply to Silviya Link to this post

    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

     

     

     

  4. Silviya
    Admin
    Silviya avatar
    422 posts

    Posted 18 Dec 2018 Link to this post

    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
  5. Gordon
    Gordon avatar
    5 posts
    Member since:
    Dec 2018

    Posted 18 Dec 2018 Link to this post

    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.

Back to Top