Boolean values different on published report

Question

I have created a report using Desktop that includes 2 Boolean fields (checkboxes) from Sharepoint Lists.

The values come into the dataset as TRUE for checked boxes.

I use this value in filters and formulae.

When I publush the report to my enterprise workspace, the visualizations do not display correctly.

I have discovered that the data from these fields are coming in as -1 for TRUE.

This of course breaks my filters and formulea that are based on these fields.

Has anyone seen this? is there a way to correct it?

Thank you in advance for you help

egsiegel · Accepted Answer

I figured it out.the columns were set to text rather than TRUE/FALSE.changing them and updating all references resolved the issue

Forum Discussion