Printing Issue

[FOE2272]

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?

[puppydogbuddy]

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.

[FOE2272]

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?

[puppydogbuddy]

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.

[NeoPa]

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).

[FOE2272]

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.

[FOE2272]

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.

[NeoPa]

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?

[NeoPa]

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?

[FOE2272]

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".

(Report Header)
     (Page Header)
          (Details)
     (Page Footer)
(Report Footer)

The answers that I am getting are saying the opposite and it just doesn't seem to make sense.

[NeoPa]

(Report Header)
     (Page Header)
          (Details)
     (Page Footer)
(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.

[FOE2272]

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.

[NeoPa]

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.

[FOE2272]

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.)

[NeoPa]

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 :)