Client called me up today telling me when they run the AR Trial Balance in SSRS, one of their clients was missing. It just happens to be the last one. In this case the client number is ZEBRA.
In the filter for customer name if I change z to zz then they show up. So as long as there is only one lowercase z they do not show. Any more than one they do show up. What could cause this.