Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count(Distinct ) problem

Status
Not open for further replies.

ReportSmithDiva1

Technical User
Jun 1, 2006
2
US
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.

 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top