Missing Sub Report Page Header Labels

[Guest]

Access 2003
I have dragged two unrelated reports into a main unbound report,
"appendices". I am doing this to be able to have consecutive page numbers
across a group of reports which form a large appendix for a document.

I find that the subreports' page header information does not show in print
preview nor does it print out.

Separately, first, how do I remove the black outline round the subreport,
and, second, how do change the width in the print of the subreport?

Thanks in advance for your help.

John

 

[Allen Browne]

To remove the black line around the subreport:
1. Open the main report in design view.
2. Right-click the edge of the subreport, and choose Properties.
3. Set the Border Style property to Transparent.

As you found the page header comes from the main report, not the subreport.
If you need to simulate a page header in the subreport, create a group
header (Sorting And Grouping box), and set its Repeat Section property to
Yes. It then repeats at the top of each new page.

This assumes you have a field that is the same value throughout the
subreport. If you don't have such a field, you can add one to the report's
source query by typing this expression into a fresh column in the Field row
(in query design):
AlwaysFalse: False
Then use this field for your repeating group header.

 

[Guest]

You don't really need to add a new field to the report's (subreport's) record
source to create a constant group level. Just set the Field/Expression in the
sorting and grouping to any constant value like:
=1

 

[Guest]

Thanks, Allen. I will try that out on Monday as its closing time here in the
UK and I'm out all day tomorrow.

Thanks again for your help,

John

 

[Marshall Barton]

Access 2003
I have dragged two unrelated reports into a main unbound report,
"appendices". I am doing this to be able to have consecutive page numbers
across a group of reports which form a large appendix for a document.

I find that the subreports' page header information does not show in print
preview nor does it print out.

Separately, first, how do I remove the black outline round the subreport,
and, second, how do change the width in the print of the subreport?

Subreport Page Headers (and Page events) are ignored
because the main report is "in charge" of page related
activities. If all the subreports have only a text box
value that's different, you can use a text box in the main
report's page header and set its value in each subreport's
report header format event:
Parent.textbox = something

In more difficult situations, change each subreport's design
to add a group header section using a constant expression
such as ="dummy page header". Then move what you have in
the subreport page header section to this new group header.
Set the group header section's RepeatSection property to
Yes.

The black outline is probably the subreport **control**
border. Just set its BorderStyle property to Trans[arent.

I don;t understand what you mean by "change the width in the
print of the subreport". Is it just to reposition and/or
change the size of the subreport control on the main report?

 

[Guest]

Thanks Allen, Duane and Marshall.

All these suggestions worked for me.

Initially I created a group header, "DummyPageHeader" with the same labels
as the page header. That worked fine, but it kept asking me for a parameter
of that name, "DummyPageHeader". I then changed the group's Field/Expression
to "=1" and it stopped asking for the parameter and just opened the report
fine.

Black borders all gone, thanks.

Subreport width, sorry, "duh!!...", I know, a dumb question - just drag the
right edge in design view.

Learned a lot since thursday - thanks guys.
--
John Whyte

Access 2003
I have dragged two unrelated reports into a main unbound report,
"appendices". I am doing this to be able to have consecutive page numbers
across a group of reports which form a large appendix for a document.

I find that the subreports' page header information does not show in print
preview nor does it print out.

Separately, first, how do I remove the black outline round the subreport,
and, second, how do change the width in the print of the subreport?

Subreport Page Headers (and Page events) are ignored
because the main report is "in charge" of page related
activities. If all the subreports have only a text box
value that's different, you can use a text box in the main
report's page header and set its value in each subreport's
report header format event:
Parent.textbox = something

In more difficult situations, change each subreport's design
to add a group header section using a constant expression
such as ="dummy page header". Then move what you have in
the subreport page header section to this new group header.
Set the group header section's RepeatSection property to
Yes.

The black outline is probably the subreport **control**
border. Just set its BorderStyle property to Trans[arent.

I don;t understand what you mean by "change the width in the
print of the subreport". Is it just to reposition and/or
change the size of the subreport control on the main report?

 

[Marshall Barton]

Thanks Allen, Duane and Marshall.

All these suggestions worked for me.

Initially I created a group header, "DummyPageHeader" with the same labels
as the page header. That worked fine, but it kept asking me for a parameter
of that name, "DummyPageHeader". I then changed the group's Field/Expression
to "=1" and it stopped asking for the parameter and just opened the report
fine.

You forgot the = sign:

="DummyPageHeader"