Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Summarizing field data Post Reply Post New Topic
Author Message
looeej
Newbie
Newbie
Avatar

Joined: 25 Jun 2015
Location: United States
Online Status: Offline
Posts: 8
Quote looeej Replybullet Topic: Summarizing field data
    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
IP IP Logged
looeej
Newbie
Newbie
Avatar

Joined: 25 Jun 2015
Location: United States
Online Status: Offline
Posts: 8
Quote looeej Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.