The issue I am referring here wouldn't have shown printing the report before and after because the Active field was copied to a new location and the information was changed on the new location. The issue started happening after new items were created and the old Active field was populated with an "I" even though the Item was active.