Solved

Sub Reports Keep together property

Posted on 2013-01-14
7
437 Views
Last Modified: 2013-01-16
I have 4 sub reports in the report footer of another report. They are not linked by any data but need to be viewed together.

I have fiddled with all aspects of the keep together, group, with first detail etc, but all seem to be ignored because they are all in the footer of another report. How do I stop a report in this situation from having the header for any of the 4 reports at the base of a page and all the detail on the following page?

I am trying to avoid page breaks after each report.

Regrettably, the reports are very involved so I cannot post a sample DB
0
Comment
Question by:DatabaseDek
  • 4
  • 3
7 Comments
 
LVL 57
ID: 38775496
If I'm understanding correctly, you would create a dummy group in the sub report (say on the expression =1), and place the sub-reports headings in that groups header.

Screenshot
Jim.
0
 

Author Comment

by:DatabaseDek
ID: 38778254
Hi

All reports work fine on there own. But when a subreport follows another in a main report's report footer they don't. Presumably because access 2002 does not know how to sort them.

Here are some screen grabs that show the problem graphically. You can see from "Capture" that the headings look OK until you see that in "Capture2" (2nd page of same report) that the last report on page one runs over into page 2. "Capture3" shows report structure in design view
Capture.PNG
Capture2.PNG
Capture3.PNG
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38778327
<<I have fiddled with all aspects of the keep together, group, with first detail etc, but all seem to be ignored because they are all in the footer of another report. How do I stop a report in this situation from having the header for any of the 4 reports at the base of a page and all the detail on the following page?>>

 If you try what I said, you'll find that the sub-reports headings will repeat on any overlow pages and I believe that will take care of your problem.

Do it in a copy of the DB.  Shouldn't take more then a few minutes to test.

 The problem is the sub-reports themselves and not the fact that they are in the main reports footer.

Jim.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:DatabaseDek
ID: 38779265
Hi Jim

I did try what you suggested and got exactly the same problem

"Capture4". shows the settings as you explained. Normally you would have any new page repeating title in the page header, View menu Tick page header footer. But what I want is the report to only appear on the remainder of any page that is large enough to hold the complete subreport. Which is where "keep together" feature is meant to come in.

I am beginning to think that the correct way is to have each subreport placed in the previous reports footer and set the report footer to keep together.

Seems a lot of grief, when all I want is to see 5 reports one after the other.
Capture4.PNG
0
 

Author Comment

by:DatabaseDek
ID: 38782506
It seems that after faffing around with this for best part of a day that the problem is that the first subreport  in any main report's report footer will obey the keep together and grouping  settings. Then, I suppose obviously when you think about it whether to fit a report at the end of a previous report will depend on the space required from the main report and then what is left will either allow or not allow the subreport to be fitted in any space below. But it cannot calculate what is left from the first and second before the third is placed. This is why I think that all reports need to be placed in the previous reports footer.

I am trying that and will get back asap
0
 
LVL 57
ID: 38782558
I can't play with it here, but one approach used in the past has been to place page breaks in the section, then at format make them visible/hidden as needed to force a page break where you want based on your current postion on the page.

 But your method might work and would be cleaner, so I would give that a shot first.

Jim.
0
 

Author Closing Comment

by:DatabaseDek
ID: 38782864
Thanks Jim

My effort has come to nowt'

Although I did solve another problem. Even when set to keep together the main form report footer (Because it has subreports) does not keep the totals together. But by drawing a Transparent box around them they keep together anyway.

Your suggestion, presumably,  would require the report length before a decision on a page break was effective I guess and would have to be deducted from that available on page 1 2 or 3 etc of the main report. Who ever could do that has my utmost respect. Too time consuming for me.

I will have to accept that on the odd occasion the report will be a little second rate and thank you again for your time.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now