Using A2K. I've got a page footer that is displayed only on the last
page of the report. There is a subreport, text boxes, and a line for
signature in this footer, in that order. If the subreport has more
than 3 records, the last text box and the signature line get cut off.
How do I format this footer so that nothing gets cut off? Thanks for
any help or advice. 3 2179
First off, I'm curious as to how you've managed to get a page footer to only
show in the last page of the report.
Other than that, I suggest that you put the subreport, text-boxes and
signature line in the Report Footer, rather than the Page Footer. Set the
Can Grow property of the Report Footer to Yes.
HTH,
Rob
<ma**********@h otmail.com> wrote in message
news:11******** *************@l 41g2000cwc.goog legroups.com... Using A2K. I've got a page footer that is displayed only on the last page of the report. There is a subreport, text boxes, and a line for signature in this footer, in that order. If the subreport has more than 3 records, the last text box and the signature line get cut off. How do I format this footer so that nothing gets cut off? Thanks for any help or advice.
I need this info to print at the very bottom of the last page. The
report footer doesn't always print at the very bottom. This newsgroup
has some good solutions to get around this.
Thanks for taking time to reply.
Rob Parker wrote: First off, I'm curious as to how you've managed to get a page footer
to only show in the last page of the report.
Other than that, I suggest that you put the subreport, text-boxes and signature line in the Report Footer, rather than the Page Footer.
Set the Can Grow property of the Report Footer to Yes.
HTH,
Rob
<ma**********@h otmail.com> wrote in message news:11******** *************@l 41g2000cwc.goog legroups.com... Using A2K. I've got a page footer that is displayed only on the
last page of the report. There is a subreport, text boxes, and a line
for signature in this footer, in that order. If the subreport has more than 3 records, the last text box and the signature line get cut
off. How do I format this footer so that nothing gets cut off? Thanks
for any help or advice.
The restriction that it must print at the bottom of the last page wasn't
clear.
Untested suggestion:
I guess you've got some code turning of the page footer visibility except
when it's on the last page - I did say I was curious about that ;-) In that
code, retrieve the height that the subreport has grown to, add the height
you need for your other textboxes and sig line, and change the height of the
Page Footer as well as making it visible.
Another thought:
It may be that you can't get the subreport height initially; perhaps put
that into the OnFormat event (which should trigger if you open the report in
preview mode), and then use it in the OnPrint event to change the height.
You'd need to store the value in a variable which is available within the
report's code module, rather than just in the Sub where you get it.
HTH,
Rob
<ma**********@h otmail.com> wrote in message
news:11******** *************@o 13g2000cwo.goog legroups.com... I need this info to print at the very bottom of the last page. The report footer doesn't always print at the very bottom. This newsgroup has some good solutions to get around this.
<snip> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Brian Coy |
last post by:
I have a database that records a part no, a scrap reason, the cost of
scrapping that item, and the date. I need to porduce a report that
will show up to a weeks worth of data at a time, but I need each dates
scrap amout totaled and each day to be separated on the report. I am
self taught at access and still a beginner, so please be gentle on
your replys.
Thanks for your time in advance...
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
|
by: Arthur Dent |
last post by:
Hello all, ive been programming with ASP.NET since it came out, but am just
getting my feet with now with v.2.
Ive noticed something strange in the way my HTML tables get rendered with 2.
I use tables to layout my pages, doing three rows, a header, content and
footer. When i do this, i make the tables height=100%,
so the footer always shows up at the very bottom of the page.
With 2.0/2005 though, when it renders the pages, it doesnt...
|
by: bj |
last post by:
Hi,
Yes, this is yet another "switching from tables to divs for layout
purposes" post. I have been searching for the past few hours to find
what I'm looking for as I hate posting unnecessarily. I am a pretty
crap searcher but I'm kinda sure this hasn't been written about yet.
Please feel free to prove me wrong and link to a solution. Otherwise
I'd appreciate any advice you may have.
I have a situation where I have a window that has...
|
by: CM |
last post by:
Hi,
Could anyone please help me?
I am completing my Master's Degree and need to reproduce a Webpage in
Word.
Aspects of the page are lost and some of the text goes.
I would really appreciate it.
The link to the document is
http://www.surveymonkey.com/s.asp?u=689952259313
I have spent 15 hours trying to sort this but to no avail.
| |
by: rsteph |
last post by:
I've found a javascript menu download, I've been tweaking it within a testpage, and getting it to look just right. I finally got everything looking right, all I have to do is alter where the links navigate to. Before I do that I'm trying to get it put into the actual page I want to use it in; right now I've been using a blank html page to test it with.
I've done everything just like it is in the test page, but the menu isn't appearing on the...
|
by: Amit |
last post by:
I have a master page and a content page but the stylesheet isnt getting
applied like how it looks in visual studio design view.
The master page is defined like this:
<%@ Master Language="VB" CodeFile="MasterPage.master.vb"
Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
by: siomay87 |
last post by:
please help
i have a problem in the ms access reporting,
my report have: page header, detail, page footer and report footer
In listing "detail section", the number of line is depend on the data source
I mean long or short in detail section is vary.
The problem is, when the detail is more than 25 line
it will give blank area below the 25th line in page 1, and page 2 continue with report footer.
This blank area in page is cause by...
|
by: mark4asp |
last post by:
Why is this page invalid?
Pasted into http://validator.w3.org/ I'm told that the page is
invalid. Why? It flags problems with the <bodyand </htmltags but
I can't see why. Is the W3C validator broke is or it my page? If it's
my page then what's wrong with it?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN" "http://
www.w3.org/TR/html4/frameset.dtd">
|
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: 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: 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.
| |