UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Subreport On Last Page?, Access 2016    
 
   
tbs
post Nov 8 2019, 09:53 AM
Post#1



Posts: 329
Joined: 12-February 13



Hi,

I have a report with several subreports. The last subreport, I want it to be on the last page of the entire report (as if there's a page break).

Is this even possible? I hope this makes sense.

Thanks in advance.
Go to the top of the page
 
LeeAnn
post Nov 8 2019, 10:52 AM
Post#2



Posts: 1,286
Joined: 2-February 00
From: Mississippi USA Central Time Zone


You can try adding a report footer on the report, place the subreport in the report footer and make the report footer property Force New Page to Before Section. let me know if that works for you.

--------------------
Lee Ann Davidson
Go to the top of the page
 
GroverParkGeorge
post Nov 8 2019, 10:56 AM
Post#3


UA Admin
Posts: 36,043
Joined: 20-June 02
From: Newcastle, WA


This is exactly how I'd try to do it as well. Of course, we always appreciate feedback on actual results.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
tbs
post Nov 8 2019, 11:29 AM
Post#4



Posts: 329
Joined: 12-February 13



That is clever! Worked like a charm.

notworthy.gif
Go to the top of the page
 
LeeAnn
post Nov 8 2019, 11:46 AM
Post#5



Posts: 1,286
Joined: 2-February 00
From: Mississippi USA Central Time Zone


Glad to hear it worked. pompom.gif

--------------------
Lee Ann Davidson
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th November 2019 - 03:56 PM