Need some help with counting in Crystal Reports
Posted on 2013-01-04
I need some help how to Create a report in Crystal reports...
I have data which contains parts used on the job.
The data looks like this:
Date Employee Number Part
1-1. 2. 2. Wheel
1-1. 2. 4. Bolts
1-1. 1. 1. Steel ring
1-1. 2. 5. Steel ring
2-1. 2. 3. Wheel
2-1. 2. 5. Steel ring
I want to Create a report which shows all the used parts and the maximum numbers used on a day. Like this:
Steel ring. 6
I can count the parts used per day. But how do i get the max numbers per part after that?
There can be a lot of parts being used.