Summarizing field data
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21910
Printed Date: 27 Apr 2024 at 11:52am
Topic: Summarizing field data
Posted By: looeej
Subject: Summarizing field data
Date Posted: 13 Mar 2016 at 5:57am
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
-------------
LooeeJ
|
Replies:
Posted By: looeej
Date Posted: 14 Mar 2016 at 3:55pm
The room isn't supporting me much so I pulled a scalp full of hair today trying to figure this out! What I embarked upon was the shared numbervar idea with sub-report. All the math works great in sub-report but just get 0's in the main report. Really thought this was the answer but no such luck :(
-------------
LooeeJ
|
Posted By: DBlank
Date Posted: 15 Mar 2016 at 4:43am
|
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.
|
|