Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Format Field Post Reply Post New Topic
Author Message
mymy17
Newbie
Newbie
Avatar

Joined: 28 Jul 2011
Location: Philippines
Online Status: Offline
Posts: 1
Quote mymy17 Replybullet Topic: Format Field
    Posted: 28 Jul 2011 at 11:11pm
ahmm good afternoon to all... im wonder if you guys can give me a hand here... im having a problem displaying the value which is on my database...

RecordID      StudentNo      Grade     ModeofPayment             SchoolFeeName    -------Fee
1--------------11-0000------Grade4      Yearly------------------Registration Fee      -------0.00
2--------------11-0000------Grade4      Yearly------------------Tuition Fee-----------   ---15715.35
3--------------11-0000------Grade4      Yearly------------------Miscellaneous Fee----       -2395.00
4--------------11-0000------Grade4      Yearly------------------Books----------------   -----5824.85
5--------------11-0000------Grade4      Yearly------------------School Supply---------      --895.00
6--------------11-0000------Grade4      Yearly------------------School Uniform(1)----      ---650.00
7--------------11-0000------Grade4      Yearly------------------P.E. Uniform(1)-------    ----680.00

thats a sample of my database and ahmm..
im having a trouble how can i display the Fee which is 2395.00 of Miscellaneous Fee
i try the LIKE thing because the School Uniform(1) and P.E.E Uniform(1) can be modify to
School Uniform(0) and P.E.E Uniform(0)

..ahmmm can you help me how can i display the Fee of Miscellaneous Fee, Books, School Supply, and School Uniform

when i try this..

if {tbl_student_fee_details.SchoolFeeName} like '* School Supply *' then {tbl_student_fee_details.Fee}
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: 29 Jul 2011 at 1:59am

what happens, does it display your value?

try if {tbl_student_fee_details.SchoolFeeName} like 'School Supply *' then {tbl_student_fee_details.Fee}
or substitute the * for ?
sharona
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 29 Jul 2011 at 7:01am
how about
if instr({table.field}, "School Supply") > 0 then xxxx else yyyy end if
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.