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.
7  3544 
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.
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.
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.
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.
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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: sztonix |
last post by:
Hi all,
I encountered a crystal report deployment problem.
I make reports with Crystal Report for Visual Studio .NET 2003. It
works fine in the development machine. And then make setup...
|
by: Tom Louchbaum |
last post by:
When I preview my Access 2000 Report it looks fine. When I Email
the report using
DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To
Address", , , "Subject", , False
the resulting...
|
by: laddie1997 |
last post by:
When I try to create a report in Access 2003, the error message
"the wizard is unable to create your report" comes up. My printer
is a network printer and no local printer is attached. I can get...
|
by: Michael S. Montoya |
last post by:
I have a report which has 3 sub-reports in the detail section. Everything
(subforms, detail section) is set to Can Grow and Can Shrink as True.
I have one record in which one of the subforms has...
|
by: Delali Dzirasa |
last post by:
I am a newbie and am creating my first asp.net in crystal reports.
I have created the report (.rpt file) and have dropped the
CrystalReportViewer on the web form.
From the databinding...
|
by: ward |
last post by:
Greetings.
Ok, I admit it, I bit off a bit more than I can chew.
I need to complete this "Generate Report" page for my employer and I'm
a little over my head. I could use some additional...
|
by: jimatqsi |
last post by:
Here's a reporting problem that keeps haunting me.
A lot of my reports give an extra page at the end, showing only headings and no data. What causes that, and how can I prevent it?
Thanks,
Jim
|
by: Micheal |
last post by:
Greetings Access Group,
Being relatively new to Access, I try to work through problems on my own and have been very successful, although I have a conundrum that I have been working on for two days...
|
by: Lukas |
last post by:
Hello
I would like to place a "Page Header"-Section before a "Report header"-
Section:
{Page header} Logo...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
