Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Font - "A" needs to be bold. "B" can stay regular Post Reply Post New Topic
Author Message
agallo22
Newbie
Newbie


Joined: 17 Jul 2012
Location: United States
Online Status: Offline
Posts: 1
Quote agallo22 Replybullet Topic: Font - "A" needs to be bold. "B" can stay regular
    Posted: 17 Jul 2012 at 5:40am
Greetings,
Can someone help me help the disabled? Need drivers to give more of a helping hand. Work for transit company. Certain customers are disabled. The report needs to show Door To Door in bold. When they get dropped off without help, Curb to Curb is the default font.

Database field that I am working with is DOOR. There are only 2 records in the field - "Door to Door" or "Curb to Curb". When report is run, need Door To Door in BOLD font. Anything else which for now it is only “Curb to Curb" needs to be stay in the "Regular/Normal font".

I have created a field object/using formula editor, field name is DoorCurb.
I inserted the Field Object into the report and shows up as @DoorCurb.

FORMULA I used is:
if 'Door To Door' in {DB.DOOR} then CRBold else CRRegular

When I preview the report - Door to Door shows up as 0.00, but when I browse field data in the database field it has the door to door as text. Not sure what the 0.00 is all about. The record is changed to a number? IDK. Spent way too long on this and need help. Any suggestions?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Jul 2012 at 7:03am

don't use a formula field (unless you need to change the actual text returned and not just the font style) but rather:

insert your DB field DB.DOOR into the report where you want it displayed
right click on it
select format field
select Font tab
click on the formula button (x-2) next to style
add your condition here
if currentfieldvalue='Door to Door' then crbold else crregular


Edited by DBlank - 17 Jul 2012 at 7:05am
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.031 seconds.