1

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.

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.