Check Box

[haneen97]

Hi, running CR 8.5,

Is it possible to have check boxes logic in crystal? The request is to have the gender and the marital status listed and check the correct one as opposed to displaying the description.

Thanks

Mo

 

[BlurredVision]

You can use one of the webding fonts to display a check box, then use a formula to display the proper box (checked or unchecked)

 

[campsys]

There is a sample report on the Business Objects web site called "How to Display a Proper Check Box". Differnet options are shown with the WingDing char# to use. Found this very helpful.

http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_formattext_samples.zip.asp

File Name: cr_formattext_samples.zip

 

[kskid]

I must be missing something. I also use Crystal 8.5

I created a text object with single line border.

I edited the box and placed a wingding 2 check (uppercase P) in it.

There is no X+2 editor for the font setting tab to allow me to enter a formula to conditional display the check.

Cheers,
-LW

 

[kskid]

Campsys,

Your post got in ahead of me.

Anyway, I tried it and it works great

haneen97,

Do the following

Create a formula for each check box you need

//@ChkFemale
//Check box for Female
if {table.sex} = "F" then
  chr(254)
else
  chr(111)

Insert the formula on your report canvas next and right click on the field object and change font to wingdings. Make it bold and whatever size you want.

That's it.

Cheers,
-LW

 

[haneen97]

campsys,
Thanks for the link, that is all I needed.

Mo