Count(Distinct ) problem

[ReportSmithDiva1]

I am trying to create a derived field to Count(Distinct) the number of payroll batches that employees have been entered into. It should return a count for each seperate batch ID but it is returning a count for every record the employee has in the batches. I have grouped the report by name. What am I doing wrong here. My system runs on oracle.

 

[CharlesCook]

Are you doing it this way?

Count(Distinct batch ID)

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

 

[ReportSmithDiva1]

Yes

 

[CharlesCook]

I have grouped the report by name."

Using Database Grouping?

Add batch ID to the Database Grouping.


CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining