Report Error

BESP10

We have a report that shows were our crews are for the day based on a start date and End date column and whether the row has been checked off as complete.

For some reason this item in row 3 of the report is showing up even though it is marked as complete and the crew was scheduled and completed the work in January

Any thoughtS?

Leibel S

@BESP10

Your filter has an OR all the way to the right which means that the Product Division filter you have there (3 Values Selected), any row that has one of those values will show up on your report regardless of the complete status...

Leibel S

@BESP10

Your filter has an OR all the way to the right which means that the Product Division filter you have there (3 Values Selected), any row that has one of those values will show up on your report regardless of the complete status...

BESP10

thank you @Leibel S

Making it an AND got rid of everything row

I just recreated and set report based on other items

Thanks for quick reply