473,698 Members | 2,972 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need help formatting page footer please

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.

Nov 13 '05 #1
3 2174
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.

Nov 13 '05 #2
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.


Nov 13 '05 #3
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>
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2478
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...
3
2735
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
4
1595
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...
2
7463
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...
8
3158
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.
4
2172
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...
8
13530
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">
1
2265
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...
9
2771
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">
0
8683
marktang
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...
0
9170
Oralloy
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...
0
9031
jinu1996
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...
1
8904
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,...
0
7741
agi2029
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...
0
5867
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4624
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3052
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
2
2341
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.