I am STUCK!
I have an Access2000 report; main report and subreport. The sub report
is 2 columns, with a footer controlled by a value in a field.
The Report Footer should have SUM of values in the report.
My problem is that the Report footer of the Subreport doesn't print!
The main report prints fine; the sub-report prints fine, except there
is NO footer.
The main report's page footer prints at the bottom of the report.
Help, Please!!
Thanks,
Sara
10  7551 
sara wrote: I am STUCK!
Ask Steve.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
sara wrote: I am STUCK!
I have an Access2000 report; main report and subreport. The sub
report is 2 columns, with a footer controlled by a value in a field.
The Report Footer should have SUM of values in the report.
My problem is that the Report footer of the Subreport doesn't print!
The main report prints fine; the sub-report prints fine, except there
is NO footer.
The main report's page footer prints at the bottom of the report.
Help, Please!!
Thanks,
Sara
Are you sure it's a Report Footer and not a Page Footer? Page Header/Footers
don't work in subreports, but Report Header/Footers should.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
I am positive it is a Report Footer - Page is empty.
It is visible, and I've tried can grow and can shrink with both yes and
no.
Now what?
Sara
Rick Brandt wrote: sara wrote: I am STUCK!
I have an Access2000 report; main report and subreport. The sub
report is 2 columns, with a footer controlled by a value in a
field.
The Report Footer should have SUM of values in the report.
My problem is that the Report footer of the Subreport doesn't
print!
The main report prints fine; the sub-report prints fine, except
there is NO footer.
The main report's page footer prints at the bottom of the report.
Help, Please!!
Thanks,
Sara
Are you sure it's a Report Footer and not a Page Footer? Page
Header/Footers don't work in subreports, but Report Header/Footers should.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
sara wrote: I am positive it is a Report Footer - Page is empty.
It is visible, and I've tried can grow and can shrink with both yes
and no.
Now what?
A subreport with columns has to be set up to snake the columns "Across, Then
Down" rather than "Down, Then Across". Is that how you have it?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Who is Steve? HOW do I ask him?
I finally got to try this - going Across, then Down, actually made it
worse! I didn't get any of my totals footers (I have one, but code
determines what's in it). The report gave me only the first 13 lines,
then no total for those lines, and none of the other items (2 other
groups have detail lines). All of these show up when I do Down, Then
Across. I just don't get the total of all of the lines, which is in
the footer.
Thanks
sara wrote: I finally got to try this - going Across, then Down, actually made it
worse! I didn't get any of my totals footers (I have one, but code
determines what's in it). The report gave me only the first 13 lines,
then no total for those lines, and none of the other items (2 other
groups have detail lines). All of these show up when I do Down, Then
Across. I just don't get the total of all of the lines, which is in
the footer.
Thanks
"Down and Across" tells the report to start a new column when the bottom margin
of the page is reached. A subreport has no way of knowing when the bottom of
the page (in the parent) is reached so you end up with a single column for all
records.
The exception to this is if you have the subreport control set to CanGrow = No.
Then the bottom of the subreport control will act as the bottom of the page. Of
course if you have CanGrow set to know that might explain why you don't see your
footer. It is likely further down than the size of the control will display.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Still not working. I even tried "force new row or column" - works when
you run the sub report by itself, but still no Report Footer from the
subreport on the main report. The main report's page footer is
showing; it doesn't have a report footer.
Any other ideas?
This is killing me!
Thanks -
sara
sara wrote: Still not working. I even tried "force new row or column" - works when
you run the sub report by itself, but still no Report Footer from the
subreport on the main report. The main report's page footer is
showing; it doesn't have a report footer.
Any other ideas?
This is killing me!
Thanks -
sara
You do have CanGrow enabled on the subreport control right?
Simplify and conquer. Remove the multi-column setting from the sub report and
change the section background color of the Report Footer. Then try it. If the
report footer is still not there you can at least see if any of the different
color appears. That will tell you if any part of the section is coming through
versus just not seeing any of the controls.
Try temporarily modifying the RecordSource of the subreport so that it only
returns one or two records and see if that makes any difference.
Heck, if you have to just substitute an unbound report as the SourceObject of
the subreport control temporarily with each section in a different color and see
what you get. You'd have to temporarily remove the MasterLink/ChildLink
settings for that test.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Trev |
last post by:
I'm just going through all reports in an application and putting a
standard report header and page footer using a subreport for each.
In the page footer's subreport I have a page number textbox:
="Page " & Report.Parent.Page & " of " & Report.Parent.Pages
When I preview the report, it says "Page 1 of 0" but printing it gives
"1 of n" where n is correct. Any way of persuading it to show the number
of pages in preview mode? (doesn't...
|
by: DFS |
last post by:
Main report contains one large graph in the detail band (no detail records).
Subreport snakes just fine (5 columns) when opening by itself. When I add
it to the main report (in the report footer), it shows just 1 column and
spills over to 5 pages.
I've tried moving the subreport to the detail band: no go. All
bands/objects are set to Grow and Shrink.
Any ideas?
|
by: Melissa |
last post by:
I have a grouped report with a subreport in the group footer. The report is
set to start a new page for each group. All the labels for fields are in the
group header and there is a subreport in the group header also. The
subreport in the group footer is based on a query. I have code in the group
header that runs a function whose value becomes part of the criteria in the
query for the subreport in the group footer. The value of the function...
|
by: Ellen Manning |
last post by:
The main report shows all medical conferences for a resident by year,
by month. A resident can attend many of the same conferences in a
year. In the year footer, I have a subreport that summarizes all
conferences and the number of times attended. This data is stored in
an array that is updated during the printing of the report detail.
I cannot do a simple grouping/counting of conferences. For some
conferences, the resident has to be...
|
by: Ellen Manning |
last post by:
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...
| | |
by: Steve Jorgensen |
last post by:
I tried to fix a problem for a client today in which report sections and even
individual text controls in some of their reports are being split across page
boundaries. Of course, I was thinking the answer was just going to be setting
some Keep Together properties to Yes. Alas, it was not to be.
It turns out that the report in question is actually a combination of 2 other
reports based on different tables. The reports should follow one...
|
by: shaqattack1992-newsgroups |
last post by:
I know this is kind of a weird question, but is there anyway to give a
subreport control of a main report?
I posted my situation earlier about having drawings print out after a
group. I have a report grouped by part group that lists the part
numbers needed from that group. I have force new page after each
group. This gives me a list of parts on each page. I want to print
the needed drawings after the groups/list of parts. There are...
|
by: Jana |
last post by:
Using Access 97.
Background:
I have a main report called rptTrustHeader with a subreport
rptTrustDetails in the Details section of the main report. The main
report is grouped by MasterClientID. There are also several other
subreports in the main report's footer. The rptTrustDetails subreport
has two grouping levels MasterClientID and ClientID, with headers and
footers for each grouping level. In the ClientID footer, I have an...
|
by: D Giles |
last post by:
Access 2003: A subreport control (sum total calculated textbox located in the subreport report footer) does not show total of all records when referenced as a total in the main report footer - only shows one record amount. When I open the subreport alone, it totals the sum of all the records which the query pulls - which is what I want. The referenced textbox in the main report footer only shows one record amount. Why is the total in the main...
|
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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
