Tip: How to Print a CheckBox for a Boolean Column in Crystal Reports?

Mahesh Chand

CheckBox Crystal ReportsCheckBox for a Boolean Column in Crystal Reports

12 Comments

Join the conversation! Your thoughts help the community grow.

umesh sheshrao15y ago
I am using below code , select({tb.Visit}) case "Business" :CHR(254) case "Transit" : CHR(254) default: CHR(168) But not getting check box . getting something like 'P' for chr(254) and '..' for chr(168)
Tevanian luck15y ago
thanks you saved my vidaaa Luck
Shijo Baby17y ago
Hi If you are looking in detail how to add checkboxes into crystal reports on a boolean feild and if the boolean field is false uncheck else check the checkbox look at this article http://checkboxcrystalreport.blogspot.com/2009/07/printing-checkbox-in-crystal-report-for.html
amar sha18y ago
Hi chand, I got a data from Database. i want to build checkbox and textbox in dynamically in crystal report based on my meta data. and also i want to checked and entered value. How can i done? i ill use Sub report? or Sections (inside) Groups. Thanks Amar
Marlene Deyo19y ago
Your tip helped me greatly to represent my true/false data as a checkbox. If the checkbox is true, it means a component has to be built for a customer order. If a date for that component is present in the database, it means the component is complete. If absent, the component is not complete. Can I highlight the checkbox if the component is complete, or make it a different color, or have some visual indicaition using color? My customer's report is currently in Access and has this capability. I am converting to VS 2005. Thanks.
- Mahesh Chand19y ago
  Sounds great Marlene.
- Marlene Deyo19y ago
  In the Fomular Workshop, I used a combination of Formula Fields... If {spCr_NewCoverage;1.Raw} = True Then Chr(254) Else Chr(168) and Formatting Formulas... if {spCr_NewCoverage;1.rptRawDate} = "" then crNoColor else crGray My problem is solved, thanks.
krishnamoorthi19y ago
we have developed a report in tabloid papersize In this report is working fine in our local system. But in client server it is diplaying half of the report in crystalreportviewer.(Like Landscape) its very urgernt ..plz give me the solution asap thanks in advance
Kevin Sheng20y ago
I got the following error message: The formula result must be a number. Any suggestions? Thanks Kevin
- Bruno Maestro19y ago
  hey man, in your formula If {YOURTABLE} = true then Chr(254) else Chr(168) If {YOURTABLE} = true -> in TRUE is the return value of dataset. the number 1 for true or 0 for false. And choose the font for WingDings sorry for my poor english :)
- krishnamoorthi19y ago
  use only numbers... ie chr(...) else char(....) instead of this replace 256 else 168
- Mahesh Chand20y agoedited
  OK my column is boolean type in the database (SQL Server) and here is the formula working fine: If {Command.HRXHC} = false then Chr(254) else Chr(168) What database are you using?

I have to display a CheckBox for a Boolean column in Crystal Reports. If the value of the column is true, the CheckBox should be checked, otherwise unchecked. Unfortunately, Crystal Reports does not provide a CheckBox control.

The workaround for this is:

Create a Formula with your column name and print Char(254) for true value and Char(168) for false value. Here is my formula look like:

If {Table.IsTeacher} = true then Chr(254) else Chr(168)

Now place the formula in your report designer and change font to Wingdings. You are all set.

This is amusing, how Business Objects folks (creator of crystal reports) can't just provide a control, which does the same. May be they will have in next version ;-)