By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,662 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,662 IT Pros & Developers. It's quick & easy.

Printing Issue

FOE2272
P: 20
I am having an issue with printing an Access Report.

The "Report Footer" is printing before the "Page Footer".

There are no forced pages.

Why?
May 25 '07 #1
Share this Question
Share on Google+
15 Replies

puppydogbuddy
Expert 100+
P: 1,923
I am having an issue with printing an Access Report.

The "Report Footer" is printing before the "Page Footer".

There are no forced pages.

Why?
Don't laugh:

The report is less than a page long.
May 25 '07 #2

FOE2272
P: 20
Thanks!

I just moved everything into the Report Footer. Didn't really want to do that in case it brings over enough data to go to a second page but, what can one do?

It may just be my opinion, but, Why would Microsoft do that?

Seems dumb.

Isn't a page a page and a report a report no matter how long?
May 25 '07 #3

puppydogbuddy
Expert 100+
P: 1,923
Thanks!

I just moved everything into the Report Footer. Didn't really want to do that in case it brings over enough data to go to a second page but, what can one do?

It may just be my opinion, but, Why would Microsoft do that?

Seems dumb.

Isn't a page a page and a report a report no matter how long?
No..what you don't realize is that the Page and Report footers are optional to begin with and can be checked or unchecked by going to the command menu and selecting "View" > Page Footer, etc.

Try unchecking the page footer for your report.
May 25 '07 #4

NeoPa
Expert Mod 15k+
P: 31,770
Wouldn't you expect the report footer to trigger before the page footer?
After all, the report finishes before the page (in the scenario outlined).
May 25 '07 #5

FOE2272
P: 20
Actually to me, It makes more sense to trigger the end of page before the end of Report, since there can be multiple pages and only one report.
May 25 '07 #6

FOE2272
P: 20
What I am really trying to get at is where a report has data at the top that can be various sizes, depending on the amount of data, and data at the bottom that is a constant size.
May 25 '07 #7

NeoPa
Expert Mod 15k+
P: 31,770
Actually to me, It makes more sense to trigger the end of page before the end of Report, since there can be multiple pages and only one report.
Even for the last page?
Surely that would be a Report Footer :confused:

Perhaps I should explain this a bit. The Page Footer is akin to margin handling in Word. The Report Footer is more like the conclusion paragraph. You wouldn't expect this to appear below the Page footer?
May 25 '07 #8

NeoPa
Expert Mod 15k+
P: 31,770
What I am really trying to get at is where a report has data at the top that can be various sizes, depending on the amount of data, and data at the bottom that is a constant size.
Do you mean this data (at the bottom) should appear for every page, or just at the end of the whole report?
May 25 '07 #9

FOE2272
P: 20
No, I want the data at the end to appear only at the end of the document not each page. But usually the data at the top is less than 1 page long, but can long longer. However, when the top data is less than 1 page the data that I want to show at the bottom appears on top.

On the other subject,

I DO understand that the page and report headers and footers can be turned off and on. but that doesn't solve the problem.

Is it just me or shouldn't, the report header & footer be triggered before the page header & footer, since they are at the "higher logical order".

Expand|Select|Wrap|Line Numbers
  1. (Report Header)
  2.      (Page Header)
  3.           (Details)
  4.      (Page Footer)
  5. (Report Footer)
The answers that I am getting are saying the opposite and it just doesn't seem to make sense.
May 29 '07 #10

NeoPa
Expert Mod 15k+
P: 31,770
Expand|Select|Wrap|Line Numbers
  1. (Report Header)
  2.      (Page Header)
  3.           (Details)
  4.      (Page Footer)
  5. (Report Footer)
The logical order of precedence you quote is simply not right I'm afraid.
Pages are no way logically within sections. It is true that a report will always finish by throwing a page, but a report is not made up of pages but of Group & Detail sections. The pages are tied to the output medium and are not a sub-definition of the report. There is even a property in the ReportFooter section 'Force new Page'. Maybe this is what you need, to do what you require, but notice it is only an option.
May 29 '07 #11

FOE2272
P: 20
OK, I'm thinking I'll just have to just live with this.

How do I fix my problem?

The only way that I can get it to look correct (with only 1 page) is to have everything in the "Report Footer". But if the top data is longer than the allowed space, everything is messed up again. and If I put anything in the "Page Footer" it doesn't show up. And everything is set to be visible including the "Page Footer" section.

Explanation:
I have a Report Header with the company logo, the report name and date span ;
I have the now() function in the Report Footer;

Here is where I'm getting lost:
The top part of data has 3 subreports that each can grow.
(placed just below the Report Header)
The bottom part of data has 4 subreports that will not grow.
(placed just above the now() field)

I want the bottom 4 subreports and the now() function to be the last things visible.

Please help me to understand how to get this to work right.

I guess I'm going to have to have someone try to explain it to me in terms I understand. because apparently, I'm just not getting it.

I know that when I do finally get it, it will make sense. But, for now it doesn't.
May 29 '07 #12

NeoPa
Expert Mod 15k+
P: 31,770
Well, it seems from your description that you've jumped right in at the deep end. I hope I can help you through, but my Sub-Report experience is limited. I wouldn't have much worries if I could see what you have directly, but doing it at a distance may prove tough for me. Let's see where we can get to.
  1. When you select Sorting and Grouping form the View menu, do you have any groups set?
  2. If so, do any of them have Group Header or Group Footer set to Yes?
  3. Other sections than that include the Page Header & Footer, the Report Header & Footer and the Detail sections.
    Where, currently (which section/s), do you have all of your sub-reports?
    I'm expecting you to say the Detail section but I need to confirm.
If you can provide answers to all of these questions, we'll see what we can do.
May 29 '07 #13

FOE2272
P: 20
Well, it seems from your description that you've jumped right in at the deep end. I hope I can help you through, but my Sub-Report experience is limited. I wouldn't have much worries if I could see what you have directly, but doing it at a distance may prove tough for me. Let's see where we can get to.

When you select Sorting and Grouping form the View menu, do you have any groups set?

If so, do any of them have Group Header or Group Footer set to Yes?

Other sections than that include the Page Header & Footer, the Report Header & Footer and the Detail sections.
Where, currently (which section/s), do you have all of your sub-reports?
I'm expecting you to say the Detail section but I need to confirm.

If you can provide answers to all of these questions, we'll see what we can do.
The main report has sorting & grouping set with 2 Fields, first one Ascending the second Descending. The Headers & Footers are turned off on the main, turned on on each of the subreports.

All of the subreports are in the Report Footer, It messes up when they are anywhere else.

I know there is probably an easier or more reccommended way to do this and if I could get an email address I could send you a screen shot of what I want this to look like.

A different way of doing this would be great, but I can't even get sum's to work in queries. That I why I did it with the subreports.

Mine is (e-mail removed as per site rules.)
May 30 '07 #14

NeoPa
Expert Mod 15k+
P: 31,770
In that case, lets see if we can get the first things working first.
Let me know the structure of your data and what you're trying to show in your report. Let's see if we cant get the queries right first. I'm hot on queries so this should get us moving more quickly :)
May 30 '07 #15

FOE2272
P: 20
In that case, lets see if we can get the first things working first.
Let me know the structure of your data and what you're trying to show in your report. Let's see if we cant get the queries right first. I'm hot on queries so this should get us moving more quickly :)
Working down the report:

First -
Company Logo & Report Name (Plus a editional calculated field) I can do this.
Next - At the top section of document (just under header)
All Bids within the past week with the following information.
Sorted by Estimator: (With also having "No Estimator Defined" catagory)
# of Bids by Estimator (Count)
% of Total Bids per Estimator
Bid Price per Estimator
Avg Price per Estimator
% of Total Price per Estimator
Sum of (# of Bids, Bid Price & Avg Price)

Sorted by Series: (With also having "No Series Defined" catagory)
# of Bids by Series (Count)
% of Total Bids per Series
Bid Price per Series
Avg Price per Series
% of Total Price per Series
Sum of (# of Bids, Bid Price & Avg Price)

Sorted by Sales Reps: (With also having "No Rep Defined" catagory)
# of Bids by Sales Reps(Count)
% of Total Bids per Sales Reps
Bid Price per Sales Reps
Avg Price per Sales Reps
% of Total Price per Sales Reps
Sum of (# of Bids, Bid Price & Avg Price)


Then at the bottom of the report
(Very Last thing, No matter how long the document is)
Sorted by Active, Sold & Dead Bids:
# of Bids by each (Count)
% of Total Bids each (Active, Sold & Dead )
Bid Price each (Active, Sold & Dead )
% of Total Price each (Active, Sold & Dead )
Sum of (# of Bids, Bid Price)
Last-
Now() Field and a text field. I can do this.
May 30 '07 #16

Post your reply

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