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 Next >>
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet Posted: 14 Aug 2009 at 12:49pm

sure did...

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
lahorichick
Groupie
Groupie


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


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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 IP Logged
lahorichick
Groupie
Groupie


Joined: 13 Aug 2009
Online Status: Offline
Posts: 54
Quote lahorichick Replybullet 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 IP Logged
<< Prev Page  of 3 Next >>
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.