Post reply

Check box in report

  • July 3, 2009 at 2:11 am

    #384906

    I like to show the check box in the report based on the value from field on database. If the value is one i have to check the check box else value is zero i have to uncheck the checkbox in the report. Is it possible to show check box in report?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • July 3, 2009 at 8:58 am

    #1019790

    Although there is no "checkbox" object in Reporting Services, you can emulate one using a TextBox, if you are willing to have an "X" instead of an actual check mark in the box.

    Create a new text box, put an "X" in it, and change the following properties to the listed values:

    BorderStyle: Solid

    Color: = IIf (Fields!MyField.Value, "Black", "White")

    Size: .175in, .175in (this fits a 10pt font; make it larger for a bigger font)

    With these setting the box will have an "X" in it for true values and be empty for false values.

    Geoff Johnson

  • July 3, 2009 at 9:01 am

    #1019792

    Thanks Geoff Johnson .

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • July 6, 2009 at 5:57 pm

    #1020782

    I tend to do this using special characters, one of two ways:

    1. Using the same text font as the rest of the report, I put a bullet character (•) for a checked textbox, and blank for unchecked. You can type the bullet by holding down Alt while typing 0149 in your numeric keypad.

    Use this textbox expression:

    =IIF(Fields!MyBooleanColumn.Value = 1,"•",Nothing)

    2. If a real check box is needed, use Wingdings characters (no guarantee how this will look on non-Internet Explorer, viz. standards-compliant browsers).

    Use this textbox expression:

    =IIF(Fields!MyBooleanColumn.Value = 1,Chr(254),Chr(168))

    Set the font for the textbox to Wingdings.

    Hope that helps!

    Nate

  • July 6, 2009 at 10:05 pm

    #1020860

    Thanks Nate. I will try it. Thanks fro your reply

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply