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_Fo rmat and
_Print events:
lngCount = lngCount + 1
If lngCount > 1 Then
Me.ReportHeader .Visible = False
End If
Thanks for any help or advice. 7 3570
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 PageheaderSecti on.
If I understand you correctly.
Darryl Kerkeslager
"Ellen Manning" <ma**********@h otmail.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_Fo rmat 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**********@h otmail.com> wrote in message
news:da******** *************** **@posting.goog le.com... 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_Fo rmat 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... 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_Fo rmat 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**********@h otmail.com> wrote in message
news:da******** *************** **@posting.goog le.com... 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... > 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_Fo rmat 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... > 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_Fo rmat 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**********@h otmail.com> wrote in message
news:da******** *************** **@posting.goog le.com... 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... > 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*********@Se eSig.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**********@h otmail.com> wrote in message >> news:da******** *************** **@posting.goog le.com... >> > 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_Fo rmat >> > 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... 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*********@Se eSig.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**********@h otmail.com> wrote in message news:da******** *************** **@posting.goog le.com... > 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*********@Se eSig.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**********@h otmail.com> wrote in message >> news:da******** *************** **@posting.goog le.com... >> > 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_Fo rmat >> > 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 package.
Installed on a windows server 2003 system (without visual studio .net
2003), the report gives error about "Logon Failed". The data source is
specified to OLE DB SQL Server, and the LogOnInfo is specified by
|
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 attachment to the email consistently does not display
all of the lines it should in one of the GroupFooters.
I am using the Print event in the report to print lines multiple times
in
|
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 round
this by specifying Adobe Acrobat Distiller as my default local printer,
but this will be irritating for users who want to use a copy of the
database. (Access will not print to the network printer at all, ie you
can't even print a query).
...
|
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 about 7 detail items and
the other subforms have several detail items. When I try and print this
record it does not get past "Formating - Hit Control-Break" in the status
line. When I delete a couple of the 7 line items, it prints fine. Is...
|
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 properties I have set the ReportSource to the path of
the report file......this cause the report viewer to display the data.
Problem is on the form at (design time "and" run time) none of the standard
| |
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 assistance. I say
additional because I've already had help which is greatly appreciated.
I do try to take the time and understand the provided script in hopes
on not having to trouble others on those. But here it goes...
|
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 (total 10 hours) and I have yet to resolve it. please excuse me for my lack of terminology, I will try to provide you with the best of information.
I currently have a report that contains 2 totals and the percentage of the difference of the 2...
|
by: Lukas |
last post by:
Hello
I would like to place a "Page Header"-Section before a "Report header"-
Section:
{Page header} Logo
___________________________________________
*
*
* {Report Header}
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |