Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Multi line items--dont want to see them Post Reply Post New Topic
<< Prev Page  of 3
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Aug 2009 at 1:52pm

Just to clarify to amke sure because this is stumping me.

1. You have 3 Running Total fields: (#charge, #wash and #shampoo)
2. All 3 are designed to Reset on Group1
3. all are placed on the Group Footer1 and display teh correct value for each.
4. You created another formula called Charge total as {#charge}-{#wash }+{#shampoo} and placed it on Group Footer1 and it only show the value from #wash.
 
Is all of this correct?


Edited by DBlank - 14 Aug 2009 at 1:53pm
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 14 Aug 2009 at 1:56pm
ah almost.
1-3 perfect
 
4...that formula is in the Group Footer1--and when the group desciption for 'charge' comes it returns the charge value 316
when group description for 'wash' comes is returns 163
and last..when group description 'shampoo' comes it returns value 118---for all other grooup descriptions it returns a 0
 
so that formula in short is returning the value for the Group footer1---just like the 3 RTwere in the respective desp groups
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Aug 2009 at 1:59pm
Dohhh.
But you need #4 (your final summary) to be in the report Footer correct.


Edited by DBlank - 14 Aug 2009 at 1:59pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Aug 2009 at 2:08pm
Assuming that is correct you need to change all of your RTs to Reset to NEVER. What is happening is it is working but it is subtracting or adding 0 because that is the value in the last group (whilereadingrecords) for both Wash and Shampoo.
If you want to display the values inthe Group Fotoers you can create other RTs for that (reset on Group1) but in order for you to use the total # of records then you need to all have them reset as Never.
Make sense?
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 17 Aug 2009 at 5:06am
ah...i would like the total for charge--in the group footer for charge..only..
 
so that formula:
 
charge - (wash + shampoo)= charge
 
i need for that to appear in the group footer for charge...so that i know that the total qty is for it
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 17 Aug 2009 at 5:57am
is there no way to pass on the running total amounts for wash and shampoo and charge --so that they just dont turn into negatives..? (i hope that made sense)
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 17 Aug 2009 at 6:19am

ok so I did what you said with changing the reset to never..it worked...

 

i'm going to make sure that the other #s didnt change in any way.

 

thank yOU

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Aug 2009 at 7:10am
Glad you got it worked out Thumbs%20Up
IP IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 17 Aug 2009 at 7:11am
ya this took a while...thank you again for your help
IP IP Logged
<< Prev Page  of 3
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.031 seconds.