G
Guest
Hi, I have a problem with reports. I have a paper form which I am
transferring to access.
I have a query which joins three tables. Each table holds data for the
report. The report displays data grouped on client names, with each client
having upto 13 topic codes to display. I have created a subreport split into
13 columns so that the codes are displayed across the page under the client
names. I have placed the subreport in the surname group header section, as
otherwise I have a duplicate set of data printed if placed in the detail
section. There should be 10 rows/records with client data (name, etc) listed
across each page, with their corresponding codes printed underneath each name.
I can get the report to print correctly if there is only one page of
records, ie. if there are between 1 and 10 records, with the correct number
of blank lines printing if there are less than ten records, at the bottom.
However, I have a problem getting it to print blank lines at the end of a
multipage report, ie if there are 48 records it should print on 5 pages with
2 blank records at the end. But it will not print the blank lines/records.
I have tried some of the code given in previous answers, but still can't get
it to print correctly. Obviously I suspect the problem is to do with both
the client data and code subform being in the group header section (and
having nothing in the detail section), but I can't get it to print just one
row of codes otherwise, ie if a client has 4 codes it prints them across the
page as it should but it duplicates them 4 times, on 4 lines.
Help!
transferring to access.
I have a query which joins three tables. Each table holds data for the
report. The report displays data grouped on client names, with each client
having upto 13 topic codes to display. I have created a subreport split into
13 columns so that the codes are displayed across the page under the client
names. I have placed the subreport in the surname group header section, as
otherwise I have a duplicate set of data printed if placed in the detail
section. There should be 10 rows/records with client data (name, etc) listed
across each page, with their corresponding codes printed underneath each name.
I can get the report to print correctly if there is only one page of
records, ie. if there are between 1 and 10 records, with the correct number
of blank lines printing if there are less than ten records, at the bottom.
However, I have a problem getting it to print blank lines at the end of a
multipage report, ie if there are 48 records it should print on 5 pages with
2 blank records at the end. But it will not print the blank lines/records.
I have tried some of the code given in previous answers, but still can't get
it to print correctly. Obviously I suspect the problem is to do with both
the client data and code subform being in the group header section (and
having nothing in the detail section), but I can't get it to print just one
row of codes otherwise, ie if a client has 4 codes it prints them across the
page as it should but it duplicates them 4 times, on 4 lines.
Help!