Solved Missing information in reports (1 Viewer)

Mal Ba

New member
Local time
Today, 15:23
Joined
Mar 6, 2021
Messages
22
I have a report based on a moderately simple query. The datasheet for the query in the report's Control Source shows all the data correctly. However when I run the report based on this query, various entries in various records are missing. So for example, whilst all the records are shown, and all the entries for the 6th, 7th, and 8th columns are shown, in the 2nd column (which should be fully populated), the entries for records 2-5.8-12,14,17-19 and so on are blank. Whereas in the 3rd column (which should also be fully populated, the entries for records 1-2,8,19,21 etc are blank. In each case the data is there in the underlying recordset.

Now to make this worse, that's what I see on Print Preview. But if I turn to Report View, the entries in the 2nd column for records 2, 8, 27-28 and so on are blank, Whereas the records which shown blank are the same ones which are blank in Print Preview. If I print it, I get the same blanks.

The information shown is fairly simple. Directly bound to the underlying recordset. It cannot be to do with the length of the records or anything like that. The 2nd column can only contain one of three texts ("Member", "Retired","Died") and in each case some of these items are shown and others not.

Just to show you I am not completely mad, I attach three screenshots where I have anonymised the data entirely but showing the three views of exactly the same data. Note that the data set is fully populated, but the reports aren't and both the Report View and the Print Preview are missing different data.

What is going on? If I can't rely on the reports because of missing information, Access becomes totally unusable for this or anything else.
 

Attachments

  • DataTable.JPG
    DataTable.JPG
    100.2 KB · Views: 34
  • Print Preview.JPG
    Print Preview.JPG
    57.8 KB · Views: 95
  • Report View.JPG
    Report View.JPG
    53.1 KB · Views: 60

Gasman

Enthusiastic Amateur
Local time
Today, 15:23
Joined
Sep 21, 2011
Messages
8,752
Looks like you have Hide Duplicates set? :unsure:

Standard reporting feature?
 

Mal Ba

New member
Local time
Today, 15:23
Joined
Mar 6, 2021
Messages
22
Nice thought. I discounted that because, whilst the records are in the same order on both views, different items are missing and if you look at the Report View.JPG there are clearly items following one another that are duplicates. However on checking I did find that Hide Duplicates was set and turning it off resolved the issue. I'm puzzled though though that Hide Duplicates seems to have a different effect on Report View and Print Preview. Ah, well. Dealt with and thanks for forcing me to look at Hide Duplicates. I should have done that at first!
 

Users who are viewing this thread

Top Bottom