Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dispaly check box Post Reply Post New Topic
Author Message
chiranchamara
Newbie
Newbie
Avatar

Joined: 14 May 2008
Location: Sri Lanka
Online Status: Offline
Posts: 1
Quote chiranchamara Replybullet Topic: Dispaly check box
     Posted: 25 May 2008 at 9:49pm
He.. Guys.....

I want to do this....
I want to design report with check box.... its like this..
I have a database and in it there is a table which has a true false for data... so i want to display checked box in report .... if the row contain true the check box should be checked if it is false check box not checked........

Can anyone give me a idea to do this.....
thank U......
ChiCha
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 28 May 2008 at 4:36pm
I don't really know how to get a check mark, but you can fairly easily put an 'X' in a box:
 
1.  Create a formula that is in a format like this:
 
if {table.field} then 'X' else ' '
 
2.  Put this formula on your report and size it to a square that the X will fit in.
3.  Right-click on the formula in the report and Format Text.  Place a border all the way around the text object.  This gives you the box.
 
-Dell
IP IP Logged
saoco77
Senior Member
Senior Member


Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Quote saoco77 Replybullet Posted: 29 May 2008 at 4:49am
You need to set the field to wingding font for the formula to work

if {table.field}=true then chr(254) else chr(168)


Note:
chr(254) is a checkbox
chr(168) is an uncheckbox


Look at Brian's book for more examples of uses for wingding font type.

Hope this helps.

Sarah
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