473,836 Members | 1,537 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

need to add text at bottom of a DETAIL list in a report

12 New Member
OK, I’m new to all this, so forgive me if I missed some easy answer to this problem!

I have a report, which is actually going to be a letter. I had no problem adding my return address, salutation and top two paragraphs in the HEADER section. I also have no problem with the DETAIL section printing out the few records I need to show. But now I want to add a closing paragraph immediately after the DETAIL section. I tried to add it in the FOOTER but that only formats a specific distance from the bottom of the page. I need it to be exactly one line from the last line in the DETAIL section. Otherwise it leaves a huge gap between the detail lines and the closing paragraph (in the footer).

---------------------------------------
HEADER
Bla bla bla bla (static text)
Bla bla bla bla
--------------------------------------
DETAIL (from 1 to 7 records (lines)
--------------------------------------
bla bla bla la (How do I add this static text?)
bla bla bla
--------------------------------------
FOOTER
Bla bla blab la (static text)


Any ideas how best to handle this? Is there a way to add a section, like a header, but between the DETAIL and FOOTER?

Peter
Feb 10 '08 #1
1 2825
mshmyob
904 Recognized Expert Contributor
Assuming you are talking about that you are in the Page footer and not the Report footer you can add another section called a grouping by RIGHT clicking on the report and add Grouping. This will add a group section just below the Detail but before the pager footer.

OK, I’m new to all this, so forgive me if I missed some easy answer to this problem!

I have a report, which is actually going to be a letter. I had no problem adding my return address, salutation and top two paragraphs in the HEADER section. I also have no problem with the DETAIL section printing out the few records I need to show. But now I want to add a closing paragraph immediately after the DETAIL section. I tried to add it in the FOOTER but that only formats a specific distance from the bottom of the page. I need it to be exactly one line from the last line in the DETAIL section. Otherwise it leaves a huge gap between the detail lines and the closing paragraph (in the footer).

---------------------------------------
HEADER
Bla bla bla bla (static text)
Bla bla bla bla
--------------------------------------
DETAIL (from 1 to 7 records (lines)
--------------------------------------
bla bla bla la (How do I add this static text?)
bla bla bla
--------------------------------------
FOOTER
Bla bla blab la (static text)


Any ideas how best to handle this? Is there a way to add a section, like a header, but between the DETAIL and FOOTER?

Peter
Feb 10 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

8
3543
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At the moment the printed output is usually going to Word. It's turning into an unholy mess, because I'm having to prepare umpteen different Word templates, and the queries that drive them, depending on what events a course has.
1
6895
by: pemigh | last post by:
I have a report with pages breaking in the middle of text box controls. And it's not just on a line-by-line basis, but sometimes (in a situation that I can no longer recreate) just the bottom portions of a line's letters were showing up at the top of a page. My experiments show that Access will ordinarily break before a text box if the whole thing won't fit, but I haven't been able to find a property that will control this behavior. I...
7
1901
by: ChadDiesel | last post by:
Hello everyone, I'm having a problem with Access that I need some help with. The short version is, I want to print a list of parts and part quantities that belong to a certain part group---One list per page. I created a report that groups the parts by part classification group with a force new page after each group. The report is based on a query of that week's orders. Some of these parts have drawings (usually 2 each stored in an...
11
16311
by: Edson Peacock | last post by:
I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high. If anyone has any suggestions they are very much appreciated. Thanks
0
1833
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would show on only the top half of each page with whitepace at the bottom of each page. How can I get the detail to fill each page with my "half page height" report footer at the bottom of the last page? Any suggestions to solve this would be...
13
14950
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would show on only the top half of each page with whitepace at the bottom of each page. How can I get the detail to fill each page with my "half page height" report footer at the bottom of the last page? Any suggestions to solve this would be...
7
13427
by: NJonge01 | last post by:
Hi, I'd like to produce a report that basically looks like an excel printout. Description: Profile Print Report Detail Section with 3 bordered text boxes all text boxes are 'abutted' against each other (where one ends, the next begins) all text boxes have the 'can grow' property set to yes. Detail Section with 'can grown' = yes
0
1564
by: retrorocket | last post by:
I've searched and searched, I could really use some suggestions. I have a Crystal Report in report designer that contains a Report Header, a Page Header, and a Detail section. The first page should print three records from the Detail section and then be followed by signature box (plain text, contains no data). If there are more than 3 records in detail, then the next pages should continue showing records but not the signature box. This...
1
1282
by: BillG | last post by:
I am developing a business app using asp.net that will have 2 different types of forms, a list view of data and then a detail view. The list views are placed on a content panel in a master page. The user can then click an Add button or edit button to add or modify an item in the list. My question is what is the best way to handle a detail form? Should the detail form appear in place of the list view in the content panel of the master...
0
9825
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
9673
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,...
0
10859
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
10560
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...
0
9388
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...
1
7795
isladogs
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...
0
6984
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();...
1
4463
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
3
3116
bsmnconsultancy
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...

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.