CrystalBox
IS-IT--Management
Hello, it's been quite a while since I last reached out to the Tek-Tip community. You guys saved me a few times on some reports i created and I thank you for that.
I created a bar chart a while back that I need to modify. I'm using Crystal reports 11 with MS Access.
Basically my chart has yearly counts of X,Y,Z which represents specific level of case events.
The fields of data I have are:
Case ID Allegations Class
12345 Discrimination Age
Failure to hire Age
Harassment Ethnicity
My goal is to get a true count of the "Class" field per Case ID. The example above returns a count of 2 under the "Class" "Age" and 1 for the "Class" "Ethnicity. because there are two "Allegations" with the same "Class", being "Age", it counts it twice. For my chart I would want to count it as one occurrence (Age). I hope that's clear enough.
I appreciate any help you can give me.
I created a bar chart a while back that I need to modify. I'm using Crystal reports 11 with MS Access.
Basically my chart has yearly counts of X,Y,Z which represents specific level of case events.
The fields of data I have are:
Case ID Allegations Class
12345 Discrimination Age
Failure to hire Age
Harassment Ethnicity
My goal is to get a true count of the "Class" field per Case ID. The example above returns a count of 2 under the "Class" "Age" and 1 for the "Class" "Ethnicity. because there are two "Allegations" with the same "Class", being "Age", it counts it twice. For my chart I would want to count it as one occurrence (Age). I hope that's clear enough.
I appreciate any help you can give me.