Report Builder Indicator showing incorrect symbol

report-builderssrs

I have a report on which I am using about a dozen indicators as a check-boxes. The data source for the report is a SharePoint list. About half of the check-boxes are displaying correctly. The other half, instead, are showing a capital A. The query I am using is:

=IIF(Fields!Quality_Record.Value="yes",1,0)

The indicator state is set up so that a value of 0 shows no icon and a value of 1 shows the check symbol. I have even deleted this indicator and replaced it with a copy of one of the working indicators and it still will only show a capital A regardless of the value of the field.

Best Answer

Well, as it turns out, someone changed the type of the field in SharePoint without documenting it and instead of yes/no, it was returning true/false and causing an error to show in place of an indicator.