It's in a report, and I've tried what you've suggested but it doesn't work. Randomly, a coworker of mine asked me what I was doing and gave me the idea of just building the report from scratch to see if something different happens and now it works correctly. Not sure why the old report wouldn't wor...