Jul 02, 2014 02:00 PM|Rion Williams|LINK
Is there any type of filtering that may be going on within these Reports and possibly stripping out some of your data? Or perhaps some type of grouping mechanism that might be leaving some of these records out?
I agree with MetalAsp.Net. I would recommend pulling the pure SQL queries that you are performing within your Reports within SQL Server directly (via SQL Server Management Studio or your preferred way to access your database) and then compare those
results to your table to see exactly which records are missing (or what fields are missing) and try to figure out why.
If you happen to find a record that isn't present, consider comparing it to records that are and try to find a reason that it might not be in there (filtering, some "active" field, etc.) and then search through the contents of your Report to try
and figure out if you might be striping it out via a filter or some other mechanism.