K
Kevin
I have a filtered report on countries with a number of text boxes and 1
subreport divided into 2 categories: (1) Status information and (2) Info on
Traings and Workshops. The subreport is included in the first group.
I need to have the two groups appear on separate pages when I print the
report. I have set the text box properties "Can Shrink" / "Can Grow" to Yes
for all but one of the text boxes, however, given that there are differing
amounts of information for each country this does not result in a uniform
appearance when the report is printed. Ideally I want the status boxes and
the subreport on the first page and the training/workshop text boxes
appearing on the second.
I've found that by inserting a page break after the last status text box
(where I have set the "Can Shrink" property to No) I achieve the result I
want except for one thing: a blank page appears between the first and second
pages in the report.
This is apparently due to the presence of the subreport on the first page
and before the page break. I've seen code (by Duane Hookom) that gets rid of
the blank page if the subreport contains no data (which is the case for some
countries):
Me.pagebreak1.Visible = Me.subrpt1.Report.HasData
I'd like to know if there is a way to modify this code so that the blank
page will also disappear when the subreport does contain data? Or if there is
another way to get rid of the blank page while keeping the subreport?
Thanks in advance for any help.
subreport divided into 2 categories: (1) Status information and (2) Info on
Traings and Workshops. The subreport is included in the first group.
I need to have the two groups appear on separate pages when I print the
report. I have set the text box properties "Can Shrink" / "Can Grow" to Yes
for all but one of the text boxes, however, given that there are differing
amounts of information for each country this does not result in a uniform
appearance when the report is printed. Ideally I want the status boxes and
the subreport on the first page and the training/workshop text boxes
appearing on the second.
I've found that by inserting a page break after the last status text box
(where I have set the "Can Shrink" property to No) I achieve the result I
want except for one thing: a blank page appears between the first and second
pages in the report.
This is apparently due to the presence of the subreport on the first page
and before the page break. I've seen code (by Duane Hookom) that gets rid of
the blank page if the subreport contains no data (which is the case for some
countries):
Me.pagebreak1.Visible = Me.subrpt1.Report.HasData
I'd like to know if there is a way to modify this code so that the blank
page will also disappear when the subreport does contain data? Or if there is
another way to get rid of the blank page while keeping the subreport?
Thanks in advance for any help.