Creating CheckBox in Crystal Reports 2008

Sometimes requirement might come where in we need to use check boxes in our reports. This document shows how to create check boxes in Crystal Reports 2008. The eFashion universe is used for the demonstration purpose. Here if the Sales Revenue is more than 10000, we need to check the box otherwise the box will be unchecked. As I earlier said this is just for demonstration purpose, actual requirements can be different. But the procedure of creating the check boxes will remain same as explained:

Steps:

1. Create a simple report using Crystal Reports 2008 as shown:

2. Create a new formula field, say check box.

3. Write following code in the formula field editor.

   If {Agg_yr_qt_mt_mn_wk_rg_cy_sn_sr_qt_ma.Sales_revenue} > 10000

   Then

   Chr(254) Else

   Chr(168);

4. Drag the formula field on the report. The report will look like this:

5. Right click the formula field. Go to the format field option.

6. Go to the tab Font and change the font to WingDings.

7. We have the final report as shown:

Thus the records which have revenue more than 10000 have checked boxes whereas the records with revenue less than 10000 have unchecked boxes. 🙂 🙂 🙂