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.
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.