Crystal Reports Multi line items--dont want to see them

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Multi line items--dont want to see them

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Aug 2009 at 12:48pm
	did you test to make sure each of the parts were getting you the right amounts by placing each in the footer? {#charge}=316 {#wash}=170 {#shampoo}=118
	IP Logged

lahorichick Groupie Joined: 13 Aug 2009 Online Status: Offline Posts: 54	Posted: 14 Aug 2009 at 12:49pm
	sure did...
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Aug 2009 at 12:51pm
	Hmm.Try and add a Report FooterB and place the formula there. Does that work? Edited by DBlank - 14 Aug 2009 at 12:51pm
	IP Logged

lahorichick Groupie Joined: 13 Aug 2009 Online Status: Offline Posts: 54	Posted: 14 Aug 2009 at 12:52pm
	nope
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Aug 2009 at 1:03pm
	Weird. I just tested that and the parenthesis are messing it up but they are not needed so try it without: {#charge} - {#wash } + {#shampoo}
	IP Logged

lahorichick Groupie Joined: 13 Aug 2009 Online Status: Offline Posts: 54	Posted: 14 Aug 2009 at 1:06pm
	{#charge}-{#wash}+{#shampoo} still get 316...ouff...NOPE i tried... {#charge}-{#wash} = 316 i tired ... {#charge}-{#shampoo} = 316 strange?? its it because they are RTs?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Aug 2009 at 1:13pm
	Really weird. I use them in formulas without issue. 1. Are you typing them in our using the fields from the Field Explorer in the Formula workshop. They should be in there starting with a Sigma. 2. You have to use these in the level that they are caclulated at so if you are resettting the value at Group Level 1 it ahs to be used at in a formula that is going to be displayed in GF1 or if you reset to Never the formual has to bein the Report Footer display. Any issues here?
	IP Logged

lahorichick Groupie Joined: 13 Aug 2009 Online Status: Offline Posts: 54	Posted: 14 Aug 2009 at 1:20pm
	1. sigma--good on this.. 2. i have it resetting on group level 1...for all of them what i noticed is.. since the formula is in the group1 footer if i go to group1 footer for a.) charge = 316 b.) wash = (163)---its showing up negative c.) shampoo = 118 b.) is showing up negative no matter if or ifnot the '()' are there?--i have a feeling thats why it might be just coming up to 316? maybe?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Aug 2009 at 1:38pm
	Negative value seems to be messing it up my sandbox as well but I do not know why. Never had to use negative values like this. Can you invert that into a positive and then add all 3 together instead?
	IP Logged

lahorichick Groupie Joined: 13 Aug 2009 Online Status: Offline Posts: 54	Posted: 14 Aug 2009 at 1:42pm
	ok so its: positivie now.. but all the values are the same.. its as though its indifferent...it only picks up the indivual #--doenst bother doing the math associated with it
	IP Logged

<< Prev Page of 3 Next >>

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