D365/AX7 – Adding conditional check box on SSRS report design

Problem

There are several requirements to add checkbox to the SSRS report design and mark it checked or unchecked based on some condition. Let’s look at the steps to add checkbox.

Solution

In order to show the checkbox marked check and unchecked based on some condition, follow the steps below.

Step#1 Insert a textbox or create a placeholder on report

Step#2 Set the font style of the textbox/placeholder as Wingdings

Step#3 Add below expression to the text box or the placeholder.

=IIF(Fields!IsEmployed.Value = "No", chr(254), chr(168))

Here,

Chr(254): Displays checked checkbox  þ

Chr(168): Displays unchecked checkbox c