access report needs fixed last page

I need a standard access report (or sub-report) to be added to my main access report as the last page.

I've found putting sub-report in report footer doesn't work, as page footer is last item to print on last page.  If I put subreport at bottom of page footer, it appears on each page.

How can I make an additional static (unbound) page always appear as last page in a single report?

Thanks much.
Larry BiedermanSoftware EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
Create a group on an expression, a good example of an expression would be: = 1.

Move this group to the highest position on your report, and turn on the group footer.  Then paste your subreport into that footer.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
It is really easy. I would but the sub report in the report footer. The key is in the report properties set the page footer not ro print withe report footer.
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
This may help:

Page footer properties
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jeffrey CoachmanMIS LiasonCommented:
lbiederman,

<I need a standard access report (or sub-report) to be added to my main access report as the last page.>
Is using a subreport a deal breaker?

Why not describe what your ultimate goal is, and see if there is another way to approach this...?

For example in many cases you can use aggregate functions as the controlsource of a textbox to get summaries that you may be getting with your subreport.
These will display on the report footer rather nicely...
=Dsum("SomeField","SomeTable")

Just throwing it out there...

;-)

JeffCoachman
0
Larry BiedermanSoftware EngineerAuthor Commented:
Hi HiTechCoach,

Tried your suggestion.  Result is that on page one, my sub-report prints above page footer, and on last page neither page footer or my sub-report prints.
I need sub report to be by itself, as last individual page.

Missing something?

Thanks, Larry
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Larry,

Are there other controls in the report's footer?  If yes, then add a page break control between the report footer's controls and the sub report. The will force the sub report onto a new page.  You may also need to set th Keep Together property to No for the report footer section.

If it were mine, I would use a separate group footer for all the controls that need to print at the end. I would only have the sub report in the report footer. Yu can tell the report footer to start on a new page.
0
Larry BiedermanSoftware EngineerAuthor Commented:
JeffCoachman,

My ultimate goal is to print this report as single PDF file.  Client wants PDF report with the last page a Back order log, all as one document.  They will then edit the last page of
PDF file (back order log).  They have electronic filing system, that requires PO and BO log to be same document.  

If I print PO as pdf, then print BO as pdf, they need to combine them, before filing.
Trying to avoid this step.

Hope that helps!

thanks, lbiederman
0
Larry BiedermanSoftware EngineerAuthor Commented:
JeffCoachman,

a sub-report is fine.
0
Larry BiedermanSoftware EngineerAuthor Commented:
Hi Fyed,

Thanks for comment.
Report has group footer, used to total report.
When I paste sub-report into group footer, the page footer follows the sub-report on last page.

I'm trying to tack on a standard last page, which follows all report and page footers.

Thanks, lbiederman
0
Jeffrey CoachmanMIS LiasonCommented:
You did not mention the PDF requirement originally...

I'll let you continue with the existing Experts...

JeffCoachman
0
Larry BiedermanSoftware EngineerAuthor Commented:
TheHiTechCoach,

Thanks again.  The report footer is empty.  What I've discovered, is the objects in a page footer follow AFTER the report footer.

So, if you have both footers, the page footer (not report footer) is final item on report!

If you put sub-report into page footer, it appears on each page.
If you put sub-report into report footer, page footer is still last thing on last page!

So how do you add something that's always last, on last page only?

Thanks, Larry
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Did you turn off the page footer so it does not print after the report footer as I previous suggested?

I do what you want to do a lot with any issues.  I also do the same thing with the report header.

FWIW: If you are creating a PDF then you can create each report separately as a PDF then merge the PDFs together. I also do that a lot.
0
Larry BiedermanSoftware EngineerAuthor Commented:
TheHiTechCoach,

Thanks again.
I need the page footer on each page, so can't turn it off.

Funny thing is, in Access, the page footer always prints AFTER the report footer on last page.
I too, always thought report footer was final item, but page footer is!

Do you know a way to auto-merge two PDF's??
Whole purpose of this project is to automatically make these two reports into one PDF.

Help appreciated much!

-Larry
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
<<I need the page footer on each page, so can't turn it off.>>
You can turn it off just for the report footer. Which is exactly what you need.


<<Funny thing is, in Access, the page footer always prints AFTER the report footer on last page.>>
Only if you leave it set to print that way. You can turn it off so the Page header/footer does not print with the report footer.

Please look at the image I posted in post ID# 37839573 above.  It shows the property to set the page footer so it print with all pages except the rep[rot footer.  Which is what I thought you wanted. Am I missing something?

See this article I wrote on the subject: Report Headers and Footers
0
Larry BiedermanSoftware EngineerAuthor Commented:
TheHiTechCoach,

Thanks again for your help.

I think what you are missing is that I need page footer to always print, even on last page.

Then, after last page prints with page footer, I need a bonus page (really a totally different report page) to print.

Its actually two reports, but I need them to print as one, so can make one PDF file, which contains both reports.
============================================
I guess a better way to ask this question is:
How can I make two Access reports output as a single PDF report file.

Sorry for confusion.
I will read your article also.

Again, Thanks for onging help

-Larry
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Since originally you said:
<<I've found putting sub-report in report footer doesn't work, as page footer is last item to print on last page>>
 I would take that to mean that you do NOT want the page footer on the last page.

Now you are saying:
<<I think what you are missing is that I need page footer to always print, even on last page.>>

I am really confused now. Can you please clarify which way you want it?

Then you said:
<<Then, after last page prints with page footer, I need a bonus page (really a totally different report page) to print.>>
Why can't you use the report footer for this bonus page?   I place a summary report int he report footer all the time. When it prints on paper or to a PDF it looks like two separate reports.

I would be glad t6o show you how to do i9t if you are willing to post a sample database with the reports and some sample data. Be sure to remove anything confidential. If that is not possible, I will see if I can create an example for you.


Did you see this in one of my previous posts:
FWIW: If you are creating a PDF then you can create each report separately as a PDF then merge the PDFs together. I also do that a lot.
0
Dale FyeCommented:
Larry,

Check out the attached example.  Note that there is a group that is defined by an expression: 1

This group has both a header (although it doesn't need one), and a footer.  If you put the subreport in the footer of this, as seen in rpt_Group_Footer, you will note that the subreport only occurs once, on the last page.

if you look at rpt_Group_Footer_w_PageBreak, you will notice that the subform (everything in that expression defined group) move to the last page.  The report footer would also print on this page if there was one defined.
SubReportOnLastPage.mdb
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
fyed,

If I understand Larry correctly, the sub report mist be on a separate page after the last page footer.  

I hope you don't mind that I took your example and modifie3d it, See the attached

 and move the sub report the report footer. I removed your grouping and the report looked identical. You really don't need the "dummy" grouping.   I do use the "dummy" grouping  technic when I need to create multiple group header/footer or multiple report footer sections.  See rpt_Group_Footer_HiTechCoach2 in the attached database

I then took that version and move the sub report print an a separate page. I even adjusted the total page count so that the next to last page shows page 3 or 3 then on page 4 it the sub report without any page footer.  See: rpt_Group_Footer_HiTechCoach in the attached database


I still am not really sure it this is really what Larry wants.  Have to wait and see what Larry thinks.
SubReportOnLastPage--HiTechCoach.mdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Larry BiedermanSoftware EngineerAuthor Commented:
TheHiTechCoach,

I have confused you by using term "last page" to mean last page of first document, and also the tagged on final, last page.

What I, trying to do is concanulate two reports, into one.

So there is last page of first report, for which I need page footer and all.
Then I need to add on a second distinctive report.

My final actual goal to to take two access reports and produce a single FTP which is report1 + report 2

Sorry, when my client explained to me, it took my 30 to understand.

Thanks again
0
Larry BiedermanSoftware EngineerAuthor Commented:
fyed,

Yes, you certainly have it working here!
Let me study it and see if I can implement.

If not, will strip down production MDB and send to you.

Many thanks for staying with my issue.
Points for you tomorrow.,

With appreciation, Larry
0
Larry BiedermanSoftware EngineerAuthor Commented:
TheHiTechCoach,

Correction!
You are consultant who sent sample database with solution.

Looks good.I'll review in morning and try to imlement.

thanks so much to both of you.

-Larry
0
Dale FyeCommented:
Boyd,

No problem, I find working in a collaborative environment most useful.
0
Larry BiedermanSoftware EngineerAuthor Commented:
Here is jpg of my report.
Thinking I need to:
-move page header into Mygroup header
-create one dummy group

Note: sample sub report is in report footer

If quicker for you, I'll send database.

Thanks much,
Larry
Report-Larry.jpg
0
Larry BiedermanSoftware EngineerAuthor Commented:
OK, I believe it works!

Thanks to you both!

-Larry
0
Larry BiedermanSoftware EngineerAuthor Commented:
The grouping routine along with turning off page footer on last page works excellent !

TheHiTechCoach, your sample database was the clincher !

Thank you both so much.  

-Larry
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.