Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Urgent Help Required.... Post Reply Post New Topic
Author Message
bczm8703
Newbie
Newbie


Joined: 12 Jul 2011
Location: Singapore
Online Status: Offline
Posts: 4
Quote bczm8703 Replybullet Topic: Urgent Help Required....
     Posted: 19 Jul 2011 at 4:40am
my table info:

bill#   item     price
0001    Books    2.00
0001    Pens     1.00
0002    Pencils 0.45
0003    Books    3.50

hi is there anyway to do a formula based on the following condition based on the table above;
display out all the price of books.. if that bill# does not have books then display 0.00
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 19 Jul 2011 at 4:45am

create a group by bill number

then add the items in the details below the group
then place price next to the item.
if there are no books it shouldnt display anything.
sharona
IP IP Logged
bczm8703
Newbie
Newbie


Joined: 12 Jul 2011
Location: Singapore
Online Status: Offline
Posts: 4
Quote bczm8703 Replybullet Posted: 19 Jul 2011 at 7:21am
Sorry my bad.... 4get to mention that the current report is already group according to its interval... The grouping info is found in my post...
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 19 Jul 2011 at 7:26am

to difficult to jump from one post to another. you asked about this specific issue. did you try my suggestion?

sharona
IP IP Logged
bczm8703
Newbie
Newbie


Joined: 12 Jul 2011
Location: Singapore
Online Status: Offline
Posts: 4
Quote bczm8703 Replybullet Posted: 19 Jul 2011 at 5:11pm
Originally posted by sharona

to difficult to jump from one post to another. you asked about this specific issue. did you try my suggestion?



what i am trying to say is that the current report has already had an existing group formula already...

Edited by bczm8703 - 19 Jul 2011 at 5:11pm
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