Check the filter. If you are filtering out records from the underlying database, then you would not see all records in the dsv. I must be missing something because it sounds like it is working as it should?