Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 11-16-2006, 06:36 PM   #1
itlearner
Registered User
 
Join Date: Jun 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
itlearner is on a distinguished road
Question Report Footer jumps to new page

I have the following sections in my report.

Report Header
Page Header
CustomerID header
Name Header
Detail
CustomerID footer
Page Footer
Report Footer

I have set Force New Page to After Section in the CustomerID Footer in order to force a new page for each customer. It works fine before the Report Footer. It means the Report Footer jumps to the new page also. How I can keep the Report Footer together with the end report details and for each customer start a new page?

__________________
Mini
itlearner is offline   Reply With Quote
Old 11-16-2006, 07:06 PM   #2
lightray
Newly Registered User
 
Join Date: Sep 2006
Location: Levin, New Zealand
Posts: 270
Thanks: 2
Thanked 0 Times in 0 Posts
lightray is on a distinguished road
A report header is usually the first page to print, and the footer is the last. If you want it to appear on each page, you need to move it to the page footer. If I understand you right. lightray
__________________
If the opposite of Love is Fear. What are you afraid of?
lightray is offline   Reply With Quote
Old 11-17-2006, 04:37 PM   #3
itlearner
Registered User
 
Join Date: Jun 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
itlearner is on a distinguished road
What I want is the first customer is on the same page with the report header, from the second customer, each customer starts with a new page. The report footer will be on the same page with the last customer.

I have tried set Force New Page to After Section in the CustomerID Footer, the first customer is on the same page with report header and from the second page, each customer starts a new page, but the report does not on the same page with the last customer, it jumps to the new page. If I set Force New Page to Before Section in the CustomerID Footer, the report footer does on the same page with the last customer but the first customer jumps to the new page. I want it on the same page with the report header.

Hope it helps to understand my question. Any other idea?

__________________
Mini
itlearner is offline   Reply With Quote
Old 11-17-2006, 04:46 PM   #4
lightray
Newly Registered User
 
Join Date: Sep 2006
Location: Levin, New Zealand
Posts: 270
Thanks: 2
Thanked 0 Times in 0 Posts
lightray is on a distinguished road
The Report Header is a once only occurance. Make sure you are distinguishing between that and your Page Header. Can you do a screen dump of the report in design mode? lightray
__________________
If the opposite of Love is Fear. What are you afraid of?
lightray is offline   Reply With Quote
Old 11-23-2006, 02:17 PM   #5
itlearner
Registered User
 
Join Date: Jun 2006
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
itlearner is on a distinguished road
Question Report Footer jumps to new page

the screen dump is attached.

what i want the report acts are:
1) the first customer is on the same page with the report header
2) the report footer is on the same page with the last customer
3) Within the report, it will be a new page for each customer from the second customer.

any idea?
Attached Images
File Type: jpg rptDSBCA.JPG (81.9 KB, 601 views)

__________________
Mini
itlearner is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Numbers: NewPageAfter group, unless last group sarahb845 Reports 1 09-05-2002 07:38 AM
Report Total Only Prints On Page # 1. skiphooper Reports 6 09-01-2002 09:39 AM
[SOLVED] supress page header on page 1 of report mikecal Reports 1 03-04-2002 10:49 AM
[SOLVED] Report footer at bottom of page KenN Reports 1 02-14-2002 09:16 AM
Breaking out of columns for the report footer Atomic Shrimp Reports 3 09-04-2001 12:23 PM




All times are GMT -8. The time now is 04:54 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World