Monday 9 May 2011

SSRS - Checkbox

Oddly, SSRS does not have a checkbox control?!!! Yes its true! So, the workaround is to do the following:
  1. create textbox (that will become your check box)
  2. change font to Arial Unicode MS
  3. in the expression window use:
    ChrW(&H2611) for a filled-in checkbox
    ChrW(&H2610) for an empty checkbox

Eg in a table's cell (text box), in the [Expression] type:
IIF(cbool(Fields!Canceled.Value), ChrW(&H2611), ChrW(&H2610))

No comments:

Post a Comment