Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: If then else not working Post Reply Post New Topic
<< Prev Page  of 3
Author Message
jeffreeze
Newbie
Newbie


Joined: 14 Sep 2012
Location: United States
Online Status: Offline
Posts: 1
Quote jeffreeze Replybullet Posted: 14 Sep 2012 at 6:07pm
did you try doing this from a view table in sql using CASE?  LOL
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Sep 2012 at 3:44am
I think youa re still just placing the original formula on the header.
You have to sum the formula field (once per formula) at the group level.
select the formula field
click on insert summary (sigma sign)
the field to sumamrize should already be your fomrual field
type should be set to sum
summary location select the group.
OK
it will insert a summary field in the group footer.
repeat per formula field
now you should have one summary as "0" or ">0" for each thing you are checking
IP IP Logged
crystalgal
Groupie
Groupie
Avatar

Joined: 20 Feb 2009
Location: United States
Online Status: Offline
Posts: 66
Quote crystalgal Replybullet Posted: 18 Sep 2012 at 4:07am
Thank you for your kind responses.
I redid my sql and now working fine. But I did learn some new tricks from you and thanks for that.
IP IP Logged
<< Prev Page  of 3
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.020 seconds.