Only labels showing up on first page of report

R

RC

The report in question has a Report Header, GroupHeader0, GroupHeader1,
Detail, and ReportFooter. In Design View the ReportHeader is empty and the
property for Visible is set as "No". For Group0 there is a one Text Box and
Label, which is associated with Group0, and several other Labels, which are
not associated with any controls. Group1 has one TextBox, and one
unassociated label, and the Detail contains the remaining Text Boxes that are
associated with the Detail part of the report.
In Print Preview only the Labels from Group0 and Group1 appear on the first
page of the report. The Labels in Group0 and Group1, and the Text Boxes in
the Detail section all show up together from the second page of the report on
to the last page. In short, only the Labels are showing up on the first page
of the report in Print Preview.
Are there any settings or properties that will cause the first page to
display the Text Boxes? Or, is there a way to prevent the first page of the
report from printing?

Thanks,
RC
 
C

cyrus05 via AccessMonster.com

As far as I understood from your text, your labels are printed on the first
page while the data is printed on the next page.
if you do not have any labels or data on the report header, simply remove it
by pulling the other section (GroupHeader0) till report header keeping no
white space between them. Similarly pull all sections upwards keeping no
additional white spaces (empty area).
Also check if you havent use any page break under lables in GroupHeader1.
If above is not your case, please specify your report structure more
preceisly.
 
R

RC

Only the labels are appearing on the first page, yet from the second page on
the labels and data both appear. The labels that are displaying on the first
page appear to be coming from GroupHeader0.
I "removed" the ReportHeader, and there was no change, but if I make the
"Visible" Property of GroupHeader0 as "No", then the first page is blank. No
Page Breaks have been used.
As the report structure is now GroupHeader0 contains one text box that holds
the name of office buildings (the report is first grouped by office building
names). Also in GroupHeader0 are labels that are not associated with any text
boxes. In GroupHeader1 is only one text box that contains the organizational
levels for staff assigned to an office building, which is a subgroup. The
Details section contains the text boxes that contain the staff member's
names, and other such demographic type data.
Thanks again
 
C

cyrus05 via AccessMonster.com

there are several posibilities for the cause of your problem. Check your page
setup and top margins. If the groupheader0 labels are displayed on the top of
the page with no data from the groupheader0 (table) then you do not have
problem with the page margins.
Is your report based on a query from two tables inter-related in one to many
relationship? If yes, I will ask you to make a new report (do not make copy-
paste anything from the previous report) leave no empty space between the
textboxes and the next section of the report, group it accordingly and tell
me the result.
Only the labels are appearing on the first page, yet from the second page on
the labels and data both appear. The labels that are displaying on the first
page appear to be coming from GroupHeader0.
I "removed" the ReportHeader, and there was no change, but if I make the
"Visible" Property of GroupHeader0 as "No", then the first page is blank. No
Page Breaks have been used.
As the report structure is now GroupHeader0 contains one text box that holds
the name of office buildings (the report is first grouped by office building
names). Also in GroupHeader0 are labels that are not associated with any text
boxes. In GroupHeader1 is only one text box that contains the organizational
levels for staff assigned to an office building, which is a subgroup. The
Details section contains the text boxes that contain the staff member's
names, and other such demographic type data.
Thanks again
As far as I understood from your text, your labels are printed on the first
page while the data is printed on the next page.
[quoted text clipped - 24 lines]
 
R

RC

Now that you mention different tables and joins, hopefully the following may
be of help. Each of several different offices has a designated person that
updates an Excel file containing the employeed directory data for their
office (all Excel files have an identical layout and headings, just
containing the data specific to that office). The Access app in which this
report is created, imports data from each of these different Excel files, and
compiles all the data into one Table ("a master employee directory") by way
of a Make Table Query and several Append Queries. The report uses this table
as its Record Source.
The company needs a report that can be printed out, yet with the report
being grouped by each office (GroupHeader0), the employees within each office
grouped by their organizational level (GroupHeader1), and the employees'
names and other demopgraphic data as the Detail . I apologize for the lengthy
explanation here, which may have been better said that the report has only
one table with no underlying joins as its Record Source, and the adding of
the grouping levels that created the GroupHeader0, the GroupHeader1, and the
Detail were all done through the Report Wizard.
Thanks once again,
--
RC


cyrus05 via AccessMonster.com said:
there are several posibilities for the cause of your problem. Check your page
setup and top margins. If the groupheader0 labels are displayed on the top of
the page with no data from the groupheader0 (table) then you do not have
problem with the page margins.
Is your report based on a query from two tables inter-related in one to many
relationship? If yes, I will ask you to make a new report (do not make copy-
paste anything from the previous report) leave no empty space between the
textboxes and the next section of the report, group it accordingly and tell
me the result.
Only the labels are appearing on the first page, yet from the second page on
the labels and data both appear. The labels that are displaying on the first
page appear to be coming from GroupHeader0.
I "removed" the ReportHeader, and there was no change, but if I make the
"Visible" Property of GroupHeader0 as "No", then the first page is blank. No
Page Breaks have been used.
As the report structure is now GroupHeader0 contains one text box that holds
the name of office buildings (the report is first grouped by office building
names). Also in GroupHeader0 are labels that are not associated with any text
boxes. In GroupHeader1 is only one text box that contains the organizational
levels for staff assigned to an office building, which is a subgroup. The
Details section contains the text boxes that contain the staff member's
names, and other such demographic type data.
Thanks again
As far as I understood from your text, your labels are printed on the first
page while the data is printed on the next page.
[quoted text clipped - 24 lines]
Thanks,
RC
 
C

cyrus05 via AccessMonster.com

It seems like your table does not contain any primary key while being created.
Check the table after the append query adds all the records in the only table,
does it append blank records from the excell sheet(s)? Open the table after
the data is imported and check if there are no blank records. If yes, you
will have to work on the append query not to import the blank rows from
excell sheets.
Now that you mention different tables and joins, hopefully the following may
be of help. Each of several different offices has a designated person that
updates an Excel file containing the employeed directory data for their
office (all Excel files have an identical layout and headings, just
containing the data specific to that office). The Access app in which this
report is created, imports data from each of these different Excel files, and
compiles all the data into one Table ("a master employee directory") by way
of a Make Table Query and several Append Queries. The report uses this table
as its Record Source.
The company needs a report that can be printed out, yet with the report
being grouped by each office (GroupHeader0), the employees within each office
grouped by their organizational level (GroupHeader1), and the employees'
names and other demopgraphic data as the Detail . I apologize for the lengthy
explanation here, which may have been better said that the report has only
one table with no underlying joins as its Record Source, and the adding of
the grouping levels that created the GroupHeader0, the GroupHeader1, and the
Detail were all done through the Report Wizard.
Thanks once again,
there are several posibilities for the cause of your problem. Check your page
setup and top margins. If the groupheader0 labels are displayed on the top of
[quoted text clipped - 25 lines]
 
R

RC

You nailed it!!! Just as you suspected, there was an empty row in the table.
Setting the Criteria to "Is Not Null" in the field, Last_Name, for the
employee's last name, in the Make Table Query and each Append Query removed
the empty row in the table. That, also removed all that empty space in the
report so that the data in the Detail section of the report now appears right
under the labels on the first page of the report.

Thanks for solving that one!


RC


cyrus05 via AccessMonster.com said:
It seems like your table does not contain any primary key while being created.
Check the table after the append query adds all the records in the only table,
does it append blank records from the excell sheet(s)? Open the table after
the data is imported and check if there are no blank records. If yes, you
will have to work on the append query not to import the blank rows from
excell sheets.
Now that you mention different tables and joins, hopefully the following may
be of help. Each of several different offices has a designated person that
updates an Excel file containing the employeed directory data for their
office (all Excel files have an identical layout and headings, just
containing the data specific to that office). The Access app in which this
report is created, imports data from each of these different Excel files, and
compiles all the data into one Table ("a master employee directory") by way
of a Make Table Query and several Append Queries. The report uses this table
as its Record Source.
The company needs a report that can be printed out, yet with the report
being grouped by each office (GroupHeader0), the employees within each office
grouped by their organizational level (GroupHeader1), and the employees'
names and other demopgraphic data as the Detail . I apologize for the lengthy
explanation here, which may have been better said that the report has only
one table with no underlying joins as its Record Source, and the adding of
the grouping levels that created the GroupHeader0, the GroupHeader1, and the
Detail were all done through the Report Wizard.
Thanks once again,
there are several posibilities for the cause of your problem. Check your page
setup and top margins. If the groupheader0 labels are displayed on the top of
[quoted text clipped - 25 lines]
Thanks,
RC
 
C

cyrus05 via AccessMonster.com

you are welcome and good luck
You nailed it!!! Just as you suspected, there was an empty row in the table.
Setting the Criteria to "Is Not Null" in the field, Last_Name, for the
employee's last name, in the Make Table Query and each Append Query removed
the empty row in the table. That, also removed all that empty space in the
report so that the data in the Detail section of the report now appears right
under the labels on the first page of the report.

Thanks for solving that one!


RC
It seems like your table does not contain any primary key while being created.
Check the table after the append query adds all the records in the only table,
[quoted text clipped - 26 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top