I have a Discoverer report for employees who are on automatic bank deposit and those who get physical checks. The report is built and returning the information I need except, on those with automatic deposit who have their check deposited to more than one account, the report is bringing back a record for each deposit. I need to get only one record for each payroll period. A TAR was logged to get some help and the result was to use the following COUNT DISTINCT command: COUNT_DISTINCT
OVER (PARTITION BY expr1 ORDER BY expr2 RANGE BETWEEN expr3 AND expr4). However, nobody in my office knows what to do with it. I am assuming the behind Count_Distinct is where I should insert the effective date field, But I am looking for only one employee per effective date. how do I express that?
Thanks,
Texanite
OVER (PARTITION BY expr1 ORDER BY expr2 RANGE BETWEEN expr3 AND expr4). However, nobody in my office knows what to do with it. I am assuming the behind Count_Distinct is where I should insert the effective date field, But I am looking for only one employee per effective date. how do I express that?Thanks,
Texanite