Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: replacing 0 data with other data Post Reply Post New Topic
Author Message
Ainey
Newbie
Newbie
Avatar

Joined: 06 Mar 2008
Location: Malaysia
Online Status: Offline
Posts: 4
Quote Ainey Replybullet Topic: replacing 0 data with other data
    Posted: 06 Mar 2008 at 2:16am

Hi Guys,

I have 4 columns and 4 rows or data it goes like this,
 
week1       week2       week3       week4
102.33          0.00         0.00           0.00
0.00             203.44      0.00           0.00
0.00              0.00          44.6           0.00
0.00               0.00          0.00           55.67
 
the outcome should be like this
102.33         203.44        44.6           55.67
 
i've tried using the suppres formula week1 = 0.00
-but obviously it wont work with the rest of the week...Confused
 
I really hope someone can help me out...Smile
Thanks in advance.
ainey
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 06 Mar 2008 at 3:52am
Hi,
 
Use the command object and paste the code below
 
select max(week1)'Week1',max(week2)'Week2',max(week3)'week3',max(week4) 'week4'
from Table 
 
Cheers
Rahul
 


Edited by rahulwalawalkar - 06 Mar 2008 at 3:52am
IP IP Logged
rvink
Groupie
Groupie
Avatar

Joined: 04 Feb 2008
Location: New Zealand
Online Status: Offline
Posts: 55
Quote rvink Replybullet Posted: 06 Mar 2008 at 12:12pm
No need to use a command, just insert a summary into the report footer for each column (sum({table.week1}) etc. That will give you the totals for each week, then suppress the detail line.
IP IP Logged
Ainey
Newbie
Newbie
Avatar

Joined: 06 Mar 2008
Location: Malaysia
Online Status: Offline
Posts: 4
Quote Ainey Replybullet Posted: 07 Mar 2008 at 2:17am
Thank you! both works!
Tongue
ainey
IP IP Logged
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.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.