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.....
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?
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.
None
0 Points
8 Posts
Missing data on report for only SOME records
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.....
Thanks!
All-Star
101931 Points
20703 Posts
Moderator
Re: Missing data on report for only SOME records
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?
All-Star
114553 Points
18503 Posts
MVP
Re: Missing data on report for only SOME records
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.