George-Bowyer
Registered User.
- Local time
- Today, 23:35
- Joined
- Dec 21, 2012
- Messages
- 178
I have a database which stores information about clubs and their staff.
I have a report which I use for printing a directory of each club in alphabetical order and their staff, with different staff types in 3 columns (subreports).
On each club form on the database, I have a button that will open the directory report filtered to that club.
This (as far as I am aware) opens the report correctly for every club, with every staff member listed.
However, if I print the 1-club report or export it to pdf, for a very small number of clubs and seemingly at random, some staff members disappear. They are there in print preview and not in print or pdf.
This is obviously not random, however, because it always affects the same people in the same clubs. The staff are listed in order of appointment date and it's the one at the bottom of the list that disappears. It does not appear to have anything to do with the number of staff. Some clubs have 6 staff printed perfectly, another might have 3 of whom 1 disappears.
This probably affects 4 or 5 clubs out of over 250.I can find no similarities to indicate a pattern.
If I run the whole report (unfiltered) the same members of staff disappear in print preview, export to pdf and printed. They are there in report view, but not there when printed or exported.
As this report goes to form a printed directory for which members pay, it is a real problem.
Many thanks,
George
PS: I know that someone is going to ask if I can post a copy to look at, but with GDPR, I don't see how I can do that...
I have a report which I use for printing a directory of each club in alphabetical order and their staff, with different staff types in 3 columns (subreports).
On each club form on the database, I have a button that will open the directory report filtered to that club.
This (as far as I am aware) opens the report correctly for every club, with every staff member listed.
However, if I print the 1-club report or export it to pdf, for a very small number of clubs and seemingly at random, some staff members disappear. They are there in print preview and not in print or pdf.
This is obviously not random, however, because it always affects the same people in the same clubs. The staff are listed in order of appointment date and it's the one at the bottom of the list that disappears. It does not appear to have anything to do with the number of staff. Some clubs have 6 staff printed perfectly, another might have 3 of whom 1 disappears.
This probably affects 4 or 5 clubs out of over 250.I can find no similarities to indicate a pattern.
If I run the whole report (unfiltered) the same members of staff disappear in print preview, export to pdf and printed. They are there in report view, but not there when printed or exported.
As this report goes to form a printed directory for which members pay, it is a real problem.
Many thanks,
George
PS: I know that someone is going to ask if I can post a copy to look at, but with GDPR, I don't see how I can do that...