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

Counting unique values for Record Count

1 Answer 177 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Andy
Top achievements
Rank 1
Andy asked on 25 Sep 2009, 07:08 AM

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.


1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 25 Sep 2009, 09:20 AM
Hi Pss Pss,

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

Sincerely yours,
Steve
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.
Tags
General Discussions
Asked by
Andy
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or