I have an ongoing issue with summaries. I always seem to struggle with this. Group summary doesn't seem to resolve what I want either. Here's what I'm tripping on...

For simplicity I have a report that has inventory on hand quantity involved.

Lg Shirt actual quantity is a total of 16. My report though has 4 lines dues to color of shirt. Red-4, Blue-4, Yellow-4 and Green-4.

I just want report to give me the total and not the count per color. I'd prefer not to group either. Just continue the report as this for example:

Lg Shirt=sum of all colors
Sm Shirt=sum of all colors
X-Lg Shirt=sum of all colors

I'd love to learn the formula at field level to take this headache away...perplexing?

J

unless you are going to alter your data source I do not think you can do what you want without either grouping or suppressing. Keep in mind crystal does not alter the original data in anyway, you can only change how you display it. I think you are trying to 'compress' our data so you can do more with it inside the report. That would have to be done in a command or stored proc or the like.