I am in need of creating a report which summarizes Test scores by Job (not by person). Each person does a particular job and is tested for it. Those people pass the "job test" by a Weak, Moderate, or Strong amount. There are ranges for that which are calculated and I am getting those to work just fine.

The problem is, I cannot print a report that shows this by Job. When I choose a sub-summary by Job, I get EACH person's score. I want to just show the total for each job i.e. Total Weak, Total Moderate, and Total strong. I have "total" fields created however it displays multiple times.

Why are they showing up as many times as there are records? I don't get it. Any help would be much appreciated.

Thanks,

Your layout needs to have a sub-summary part (when sorted by Job). Place summary fields in this part, and delete the Body part (this is the part that shows individual records).

Yes, but when I do that... I see each record in browse mode but it does not show anything in Preview mode. It only shows the header and footer.

I've tried it with a Script being created and without. there is no sliding/Printing issues. Does this mean there is a calculation error or something?

Nevermind. I figured it out. It was Relational issue with another table. My bad. It worked. thanks!