Including Checkbox in SQL Server Reporting

Description: Suppose we have a form that should appear automatically filled out based on information pulled from a database. We have several datatype fields. Printing out “True” or “False” , “Yes” or “No” on the required field as per the information wuldn’t look nice, as this is supposed to look like a form that has been auto-filled out, so we want to have a checkbox or a series of checkboxes that are either checked or unchecked.  We can add checkbox control through following ways 1.by Images

2.by Textboxes

Through Images:

1.First to create 2 Images of checkbox.Then add embedded Images to the report(named as “Checked” and “Unchecked”).

2.Insert an Image object and display 1 of the 2 images as per the field value or as per your conditional expression like as follows

IIF(First(Fields!Field.Value,”DataSetName”)=true,”Checked”,”Unchecked”)
  or

IIF(Conditional_Expression=true,”Checked”,”Unchecked”)

Through Texboxes:

1.Create a Texbox that must look like checkbox.

2.Change font to Webdings.

3.Display value  “tick” or “cross” mark as per the field value or conditional expression like as follows

IIF(First(Fields!Field.Value,”DataSetName”)=true,”a”,”r”)

                    or

IIF(Conditional_Expression=true,”a”,”r”)

Note:
If you want to display a checkbox inside the cell of a Table or Matrix, then at first add “Rectangle” to the cell after that you can add Texboxes or Images to it.

150 150 Burnignorance | Where Minds Meet And Sparks Fly!