Counting unique values for Record Count

2 posts, 0 answers
  1. U4
    U4 avatar
    13 posts
    Member since:
    Oct 2012

    Posted 25 Sep 2009 Link to this post

    Hello Telerik team,

    To achieve the number of records for a group footer or a Report footer we used =Count(‘fieldname’)


    But I have a scenario where in I need to count only unique values for my number of records for both Group Footer and Report Footer.


    For example:

    I'm printing a report for leave applications


    1 employee applied a 5 days leave in one transaction (The transaction was tag with an ID)

    So I got 5 Rows with Same ID.


    When I try to display a report it will always show me 5 records which is correct, but how do I count the unique ID? I dont want my number of record to be counted as 5 records instead I want the count of the unique ID.

  2. Steve
    Steve avatar
    10941 posts

    Posted 25 Sep 2009 Link to this post

    Hi Pss Pss,

    Please review this KB article for more info on Implementing and using custom aggregate functions.

    Sincerely yours,
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Back to Top