locked
How to display checkbox in crystal report

    Question

  • Dear all.

    I'm working with vb.net 2005 and I've created a crystal report that passes parameter to the report form. No problem there.

    Since my database consists of few checkboxes, I was wondring if someone can tell me how do to display them in my crystal report.  Either an explaination or sample code.

    I appreaciate your help.

     

    Mel

    Monday, January 15, 2007 4:09 PM

Answers

  • I read in an article somewhere,

    in your stored procedure you do something like this

    case when myField = 1   then char(110) else char(111) end as myField

    Then in your CR report you bind 'myField' and set it font to WingDings, the result is an empty box for 0 and black box for 1.

    You can replace the char 110 with the corresponding check mark char.

     

    Hope this helps.

    Sunday, February 18, 2007 11:38 PM

All replies

  • I read in an article somewhere,

    in your stored procedure you do something like this

    case when myField = 1   then char(110) else char(111) end as myField

    Then in your CR report you bind 'myField' and set it font to WingDings, the result is an empty box for 0 and black box for 1.

    You can replace the char 110 with the corresponding check mark char.

     

    Hope this helps.

    Sunday, February 18, 2007 11:38 PM
  • 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
    Saturday, July 18, 2009 10:36 AM
  • Dear All,

    I would like to know the ascii char code for radio button(selected as well as for unselected) to display in crystal report. I would appriciate if any one can shre their thought.

     

     

    Monday, March 14, 2011 1:52 PM
  • Hi,

    Try this

    Ascii Char code for Selected Radio Button: 164

    Ascii Char code for UnSelected Radion Button:161


    R.Mani http://rmanimaran.wordpress.com
    Tuesday, March 15, 2011 4:19 AM
  • Thank you much Mani :-) it works fine
    Wednesday, March 16, 2011 2:43 AM