Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula to display zero if no data is returned Post Reply Post New Topic
Author Message
Kosmo QA
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 8
Quote Kosmo QA Replybullet Topic: Formula to display zero if no data is returned
     Posted: 08 Jul 2008 at 9:52am
Hello.
I have a report that I've created in Crystal XI that displays the value of parts scrapped in a week on a bar graph.  Currently if there is no data returned due to no parts being scrapped nothing is displayed on the graph.  Is it possible to write a formula to tell the report to display $0.00 in these instances?
"Why does life go by so fast when days just creep along?"
--Fighting Gravity--
IP IP Logged
MadManJiggs
Newbie
Newbie
Avatar

Joined: 09 Jun 2008
Online Status: Offline
Posts: 10
Quote MadManJiggs Replybullet Posted: 08 Jul 2008 at 11:32am
Just do A If A then '$0.00'

ELSE
    ToText 'B'
CJ
IP IP Logged
venkatesha
Newbie
Newbie


Joined: 29 Jun 2008
Online Status: Offline
Posts: 35
Quote venkatesha Replybullet Posted: 08 Jul 2008 at 10:54pm
Use the below formula

if(IsNull(Count({Sno.Clerk}))) then
 '$0.00'
IP IP Logged
Kosmo QA
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 8
Quote Kosmo QA Replybullet Posted: 29 Jul 2008 at 5:39am
Thanks.  I have created a formula using the method you suggested, but, I am not able to select this formula and use it in the Chart Expert in the Show Value box.  Anyone know why this is?
"Why does life go by so fast when days just creep along?"
--Fighting Gravity--
IP IP Logged
venkatesha
Newbie
Newbie


Joined: 29 Jun 2008
Online Status: Offline
Posts: 35
Quote venkatesha Replybullet Posted: 30 Jul 2008 at 6:53am
Having doubt to display chart. Try this

Have two sections one having chart and other displaying 0.00.

When data is available display the chart section. When there is no data display 0.00 by using suppress section.

Cheers
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.