By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Formatting subreport "report" headings

P: n/a
I've got an A2K report showing students and their costs. Student info
is in the main report and costs are in a subreport for each student.
The user inputs the program desired then only those students in that
program are printed.

I want the subreports headings to print only for the first student on
the page. Is there a way to suppress printing of the headings on
subsequent students on that page?

I tried the following in both the subreports' ReportHeader_Format and
_Print events:

lngCount = lngCount + 1

If lngCount > 1 Then
Me.ReportHeader.Visible = False
End If

Thanks for any help or advice.
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Have you looked at Page Header Sections? It sound like you may want to add
Page Headers, and use them to contain your subreport headers. You can then
make them visible or not using the Format event of the PageheaderSection.
If I understand you correctly.

Darryl Kerkeslager

"Ellen Manning" <ma**********@hotmail.com> wrote:
I've got an A2K report showing students and their costs. Student info
is in the main report and costs are in a subreport for each student.
The user inputs the program desired then only those students in that
program are printed.

I want the subreports headings to print only for the first student on
the page. Is there a way to suppress printing of the headings on
subsequent students on that page?

I tried the following in both the subreports' ReportHeader_Format and
_Print events:

lngCount = lngCount + 1

If lngCount > 1 Then
Me.ReportHeader.Visible = False
End If

Thanks for any help or advice.

Nov 13 '05 #2

P: n/a
Open your subreport in design view.

If you do not see a Report Header section (grey bar across the page), choose
Report Header/Footer on the View menu.

Move the headings from the group header into the Report Header. They should
now show only at the top of the subreport, not on each page. (I'm assuming
the subreport is showing them because the group header's Repeat Section
property is set to Yes.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
I've got an A2K report showing students and their costs. Student info
is in the main report and costs are in a subreport for each student.
The user inputs the program desired then only those students in that
program are printed.

I want the subreports headings to print only for the first student on
the page. Is there a way to suppress printing of the headings on
subsequent students on that page?

I tried the following in both the subreports' ReportHeader_Format and
_Print events:

lngCount = lngCount + 1

If lngCount > 1 Then
Me.ReportHeader.Visible = False
End If

Thanks for any help or advice.

Nov 13 '05 #3

P: n/a
Thanks to both of you for your replies. I tried moving the headings
to the page header before posting but the headings did not print at
all. Maybe if I demo what this report looks like:

<student name and info> <subreport showing this students'
costs>
-------------------------------------------------------------------------
<student name and info> <subreport showing this students'
costs>
-------------------------------------------------------------------------
.....and so on and on....

I want the headings to print only for the first student on the page.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
Open your subreport in design view.

If you do not see a Report Header section (grey bar across the page), choose
Report Header/Footer on the View menu.

Move the headings from the group header into the Report Header. They should
now show only at the top of the subreport, not on each page. (I'm assuming
the subreport is showing them because the group header's Repeat Section
property is set to Yes.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
I've got an A2K report showing students and their costs. Student info
is in the main report and costs are in a subreport for each student.
The user inputs the program desired then only those students in that
program are printed.

I want the subreports headings to print only for the first student on
the page. Is there a way to suppress printing of the headings on
subsequent students on that page?

I tried the following in both the subreports' ReportHeader_Format and
_Print events:

lngCount = lngCount + 1

If lngCount > 1 Then
Me.ReportHeader.Visible = False
End If

Thanks for any help or advice.

Nov 13 '05 #4

P: n/a
That's correcct, Ellen. The page headings do not print in the subreport.

You need to use the Report Header of the subreport, not the Page Header.
They are both on the View menu when you open the subreport in design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
Thanks to both of you for your replies. I tried moving the headings
to the page header before posting but the headings did not print at
all. Maybe if I demo what this report looks like:

<student name and info> <subreport showing this students'
costs>
-------------------------------------------------------------------------
<student name and info> <subreport showing this students'
costs>
-------------------------------------------------------------------------
....and so on and on....

I want the headings to print only for the first student on the page.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message

news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
Open your subreport in design view.

If you do not see a Report Header section (grey bar across the page),
choose
Report Header/Footer on the View menu.

Move the headings from the group header into the Report Header. They
should
now show only at the top of the subreport, not on each page. (I'm
assuming
the subreport is showing them because the group header's Repeat Section
property is set to Yes.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
> I've got an A2K report showing students and their costs. Student info
> is in the main report and costs are in a subreport for each student.
> The user inputs the program desired then only those students in that
> program are printed.
>
> I want the subreports headings to print only for the first student on
> the page. Is there a way to suppress printing of the headings on
> subsequent students on that page?
>
> I tried the following in both the subreports' ReportHeader_Format and
> _Print events:
>
> lngCount = lngCount + 1
>
> If lngCount > 1 Then
> Me.ReportHeader.Visible = False
> End If
>
> Thanks for any help or advice.

Nov 13 '05 #5

P: n/a
I'm using the report header. But I'm getting this result:

Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
.....and so on and on....
But this is the result I want:

Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
.....and so on and on....


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
That's correcct, Ellen. The page headings do not print in the subreport.

You need to use the Report Header of the subreport, not the Page Header.
They are both on the View menu when you open the subreport in design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
Thanks to both of you for your replies. I tried moving the headings
to the page header before posting but the headings did not print at
all. Maybe if I demo what this report looks like:

<student name and info> <subreport showing this students'
costs>
-------------------------------------------------------------------------
<student name and info> <subreport showing this students'
costs>
-------------------------------------------------------------------------
....and so on and on....

I want the headings to print only for the first student on the page.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message

news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
Open your subreport in design view.

If you do not see a Report Header section (grey bar across the page),
choose
Report Header/Footer on the View menu.

Move the headings from the group header into the Report Header. They
should
now show only at the top of the subreport, not on each page. (I'm
assuming
the subreport is showing them because the group header's Repeat Section
property is set to Yes.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
> I've got an A2K report showing students and their costs. Student info
> is in the main report and costs are in a subreport for each student.
> The user inputs the program desired then only those students in that
> program are printed.
>
> I want the subreports headings to print only for the first student on
> the page. Is there a way to suppress printing of the headings on
> subsequent students on that page?
>
> I tried the following in both the subreports' ReportHeader_Format and
> _Print events:
>
> lngCount = lngCount + 1
>
> If lngCount > 1 Then
> Me.ReportHeader.Visible = False
> End If
>
> Thanks for any help or advice.

Nov 13 '05 #6

P: n/a
If you are getting that result when using the Report Header section of the
subreport, then it must be running another instance of the subreport for
each student.

If that is the case, you will have to move the heading text out of the
subreport, and place it on the main report somewhere where it shows only
once for the main report, e.g. the Report Header of the main report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
I'm using the report header. But I'm getting this result:

Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
....and so on and on....
But this is the result I want:

Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
....and so on and on....


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
That's correcct, Ellen. The page headings do not print in the subreport.

You need to use the Report Header of the subreport, not the Page Header.
They are both on the View menu when you open the subreport in design
view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
> Thanks to both of you for your replies. I tried moving the headings
> to the page header before posting but the headings did not print at
> all. Maybe if I demo what this report looks like:
>
> <student name and info> <subreport showing this students'
> costs>
> -------------------------------------------------------------------------
> <student name and info> <subreport showing this students'
> costs>
> -------------------------------------------------------------------------
> ....and so on and on....
>
> I want the headings to print only for the first student on the page.
>
>
>
> "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message

news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
>> Open your subreport in design view.
>>
>> If you do not see a Report Header section (grey bar across the page),
>> choose
>> Report Header/Footer on the View menu.
>>
>> Move the headings from the group header into the Report Header. They
>> should
>> now show only at the top of the subreport, not on each page. (I'm
>> assuming
>> the subreport is showing them because the group header's Repeat
>> Section
>> property is set to Yes.)
>>
>>
>> "Ellen Manning" <ma**********@hotmail.com> wrote in message
>> news:da*************************@posting.google.co m...
>> > I've got an A2K report showing students and their costs. Student
>> > info
>> > is in the main report and costs are in a subreport for each student.
>> > The user inputs the program desired then only those students in that
>> > program are printed.
>> >
>> > I want the subreports headings to print only for the first student
>> > on
>> > the page. Is there a way to suppress printing of the headings on
>> > subsequent students on that page?
>> >
>> > I tried the following in both the subreports' ReportHeader_Format
>> > and
>> > _Print events:
>> >
>> > lngCount = lngCount + 1
>> >
>> > If lngCount > 1 Then
>> > Me.ReportHeader.Visible = False
>> > End If
>> >
>> > Thanks for any help or advice.

Nov 13 '05 #7

P: n/a
Yeah, that's what I was afraid I'd have to do. The subreport format
changes with the program the user selects so I was hoping to be able
to print the headings only once. Oh well...thought I would check here
first if anyone had had the same situation.

Thanks for your replies.


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
If you are getting that result when using the Report Header section of the
subreport, then it must be running another instance of the subreport for
each student.

If that is the case, you will have to move the heading text out of the
subreport, and place it on the main report somewhere where it shows only
once for the main report, e.g. the Report Header of the main report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
I'm using the report header. But I'm getting this result:

Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
....and so on and on....
But this is the result I want:

Heading 1 Heading 2...
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
<student name and info> <subreport showing this students' costs>
-------------------------------------------------------------------------
....and so on and on....


"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
That's correcct, Ellen. The page headings do not print in the subreport.

You need to use the Report Header of the subreport, not the Page Header.
They are both on the View menu when you open the subreport in design
view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ellen Manning" <ma**********@hotmail.com> wrote in message
news:da*************************@posting.google.co m...
> Thanks to both of you for your replies. I tried moving the headings
> to the page header before posting but the headings did not print at
> all. Maybe if I demo what this report looks like:
>
> <student name and info> <subreport showing this students'
> costs>
> -------------------------------------------------------------------------
> <student name and info> <subreport showing this students'
> costs>
> -------------------------------------------------------------------------
> ....and so on and on....
>
> I want the headings to print only for the first student on the page.
>
>
>
> "Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>... >> Open your subreport in design view.
>>
>> If you do not see a Report Header section (grey bar across the page),
>> choose
>> Report Header/Footer on the View menu.
>>
>> Move the headings from the group header into the Report Header. They
>> should
>> now show only at the top of the subreport, not on each page. (I'm
>> assuming
>> the subreport is showing them because the group header's Repeat
>> Section
>> property is set to Yes.)
>>
>>
>> "Ellen Manning" <ma**********@hotmail.com> wrote in message
>> news:da*************************@posting.google.co m...
>> > I've got an A2K report showing students and their costs. Student
>> > info
>> > is in the main report and costs are in a subreport for each student.
>> > The user inputs the program desired then only those students in that
>> > program are printed.
>> >
>> > I want the subreports headings to print only for the first student
>> > on
>> > the page. Is there a way to suppress printing of the headings on
>> > subsequent students on that page?
>> >
>> > I tried the following in both the subreports' ReportHeader_Format
>> > and
>> > _Print events:
>> >
>> > lngCount = lngCount + 1
>> >
>> > If lngCount > 1 Then
>> > Me.ReportHeader.Visible = False
>> > End If
>> >
>> > Thanks for any help or advice.

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.