I have a report that I'm trying to sort by Bed number but, the sorting is random. I have the Sorting in the Tablix properties set to sort by the "bed" field. This is a List report so, I'm not sure if that has anything to do with it. The underlying stored procedure sorts correctly. Any thoughts?