Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Need to report zero amounts too Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 May 2010 at 6:31am
If your @billed formula is not using "Default values for NULLS" it will not evaluate (return NULL) when either CLASS or AMOUNT is Null.
 
Showing row level data what do you want to calculate and in what manner?


Edited by DBlank - 03 May 2010 at 6:32am
IP IP Logged
dee-jo
Newbie
Newbie


Joined: 29 Apr 2010
Location: United States
Online Status: Offline
Posts: 13
Quote dee-jo Replybullet Posted: 03 May 2010 at 6:48am
Now that I changed the join, everything is working fine, except one last item.  It now doesn't let my @CAC subtotal fields work.

They were set up as running totals, and the @CAC formula was:
 
ToNumber ({JC_CONTROLESTIM.USER2})
 
However, now it says "The String is Non Numeric" when you print.  If I eliminate the ToNumber from the formula, then I can't get the Subtotal to work. 

The @CAC represents the Cost At Completion field and is a custom field on the Cost code.  It is not specifically a numeric field which is why I was trying to convert it to one.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 May 2010 at 6:52am
YOu have to decide what to do if it the value is not numeric. Do you make that 0?
 
if isnumeric({JC_CONTROLESTIM.USER2}) then ToNumber ({JC_CONTROLESTIM.USER2}) else 0
IP IP Logged
dee-jo
Newbie
Newbie


Joined: 29 Apr 2010
Location: United States
Online Status: Offline
Posts: 13
Quote dee-jo Replybullet Posted: 03 May 2010 at 8:25am
DBlank,
Thanks so much for all your time!  You've solved my report issue!  I've learned so much!

Thanks again,
 
dee-jo
IP IP Logged
<< Prev Page  of 2
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.