Last post Jul 02, 2014 02:00 PM by Rion Williams
Jul 02, 2014 01:30 PM|schavez19|LINK
There seems to be only a few random clients who's data does not show up in a report. While other client data show up fine in
same report? I have confirmed that the "missing" data is indeed in the database table for clients w/missing data.
Since I cannot repeat the same behavior for every record I'm at a lost to correct this. Very odd that this issue only appears in certain clients? Please advise.....
Jul 02, 2014 01:33 PM|MetalAsp.Net|LINK
Here's what I would do. You have some SELECT statement to retrieve the data for the report generation. Run that statement in ssms manually for a client that you know the report is broken for. Do you get any rows?
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.