Skip to Content
0
Former Member
Nov 02, 2009 at 09:04 PM

SQVI - Quick Viewer - Avoid Duplicates

505 Views

Hi All,

I am running a Quick Viewer and need to display the Count of records for each month.

Now I have 2 records for each Employee.(Say 1 for dental and 1 for medical)

Say I have 5 employees,So I could display the Count as 10 records.

But in Actual I need to display the count as 5 because there are 5 employees.

Since in my dataset 2 records are fetched for each employee,Record count is many a times double the employee count .

Is there anyway we could avoid duplicates in Quick viewer.

Edited by: Kumar B on Nov 3, 2009 9:48 AM