Crystal Report does not have built in support to display a check box for Boolean operators or to display a radio button, but it can be achieved as explained below:
The simplest way to accomplish this task is to
1) Edit the display string of the value in Format Editor as shown below.
Figure 1: Format editor display string
2) Set the font of the object to Wing Ding.
First we need to add a formula to change the display text of the field. Right click on the field that we would like to change, and select “Format Field”. On the Common tab, click the “X+2” button for the “Display String” option and copy the formula as shown in figure
Ensure that “Crystal Syntax” is selected and write the formula content as shown in below screenshot:
Figure 2: Changing the display string
Click “Save and close”.
Now, change the font to “Wingdings” as shown in below screenshot.
Figure 3: Changing the Font to Wingdings:
Suppose we have data as shown below which shows whether an employee has opted for Medical, Dental and Basic Life coverage or not.
Figure 4: Data in Excel format:
Now run the report. We get report output as shown below in figure 5.
Figure 5: Crystal Report output:
In the above Crystal output we can see that check box is checked where we have “Yes” value in Excel data and check box is unchecked for “No” value.
P.S: To display a radio button we need to use chr(164) for selected radio button and chr(161) for unselected radio button with “Wingdings” font.