access report multiple columns: column interruption

I have an access report with two columns, with a group header and the body. The group header has 4 subreports. I want the subreports to print in one section, not to be split one part in one column and one part in next column. Is there any way to keep each subreport in one column?
column.png
Progold S.p.A.IT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
If I am understanding you correctly, the answer would be no.

You can't have a report laid out like this

Main report ---------------------------------- headings

 SR1    SR2     SR3     SR4


with each sub-report in a single column that would span multiple pages.   When doing a sub-report, the report engine will move over to the next column when it hits the bottom of the page.    If you restricted SR1 to a single column, it would continue onto the next page, but it would not go back a page to start sub-report 2.

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You need to put all your text into a single sub-report and let it span columns.

Jim.
0
Progold S.p.A.IT ManagerAuthor Commented:
the report is built as you see in the attached file
report.png
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
OK, think I have it now....you want the "Hand" icon at the top of the second column, which is the start of a sub-report?

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Assuming that is correct, open a sub-report, add a report header, and in the properties for that, change the "New Row of Col" property to "Before Section".

Jim.
0
Progold S.p.A.IT ManagerAuthor Commented:
ok, thank you. I'll try and let you know
0
Progold S.p.A.IT ManagerAuthor Commented:
Dear Jim, it's not working. subreport is split again
In the attached file, I've highlighted the subreport. In this case the yellow box is split
report.png
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Not sure why that didn't work....let me do up a quick test and I'll get back to you in a bit

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You did do it in the report header yes?   You can't use the page headings.   They are ignored on sub-reports.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< Is there any way to keep each subreport in one column?>>

  Is this for one specific report and/or are the sub report sections variable in size?

  I played around with this a bit and the question is; when do you move to a new column?   The issue is that you don't know how big the sub-report will be.

 In the image you posted with the question, if the first few sub reports in column one were larger, then the sub report with the hand icon that you indicated should start in column two might be in column two already.

 Because of that, there is no easy way to solve this.    I do believe there is a way, but it would take some doing.  What you'd have to do is put the report into two pass mode, record the start and end of each sub report, then on the second pass, drop down a number of lines so that it bumped over to the next column.    I did this years ago with someone that was trying to produce a college transcript.  

 If however the sub reports are fixed in size, then the simplest solution is to use a single column on the master report and simply arrange the sub reports manually as needed (some on the left, some on the right, and use page break controls to get additional pages).

  Fill in some more details and we will see what can be done.

Jim.
0
Progold S.p.A.IT ManagerAuthor Commented:
Dear Jim, it's how you think. All sub reports are variables in size, so it could happen that all sub reports fit in the first colums or that they shift also to the second.
when do you move to a new column?   The issue is that you don't know how big the sub-report will be.  yes, that's the point
I think I have to record the start and the end of each sub report. Can you suggest me the vb function to get these values? thank you
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I think I have to record the start and the end of each sub report. Can you suggest me the vb function to get these values? thank you>>

  What is your time frame on getting this working?   I ask only because if we start, I would like to see it through, but this could easily turn into days (I am pretty busy right now with regular work).

 I did however take the time yesterday to dig for the old question I referred to, which is here:

https://www.experts-exchange.com/questions/21337346/How-can-I-put-a-continuation-footer-at-the-end-of-each-individual-column-in-a-multi-column-report.html

 It is a long read and a little confusing because it covers a lot of different things,  but it contains several different ways that you might approach something like this and the problem was similar.

My approach would be to use the "two pass" feature of the report engine.

By referring to "pages" in a hidden control, you force the report engine to do the report twice; one non-printing pass so it can figure out the number of pages, and then a second pass to actually print.

On the first pass, we'd record the start page/column of a section, and also the end page/column.   What were looking for here is, "Does the section fit in a single column?"    If the answer is yes, then we'd want to bump it to a new column.   If the answer is no, then there is no reason not to print it right where it is.  

On the second pass as we print each section, we'd see if it would fit and move to a new column by using the MoveLayout, NextRecord, and PrintSection properties.

Does that sound like what you would like to end up with?

Doing this will require dropping the use of the sub-reports and placing everything in the main report with groups.   It is also possible that in doing this, we may find that just using built-in options may give you the output you want as Groups have the "Force new row or column" property (In fact I think it will).

If you want to tackle this with me, then it would be best if you could put together a small sample database with just the report and the required data so we can work on it.

Jim.
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
Progold S.p.A.IT ManagerAuthor Commented:
Thank you so much Jim, I'm going to read the old question and try to carry out. I'll ask you again in case I have  other questions and eventually share the project. Thank you very much, you helped me a lot
0
Progold S.p.A.IT ManagerAuthor Commented:
great help
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Thank you so much Jim, I'm going to read the old question and try to carry out. >>

 There is a lot there.  Please return here and ask anything in regards to it.

 I think though unless you have a specific reason for doing the sub reports, you would be better to "flatten" the data and do it all within the main report using groups.

 With that, I think you can then use the built-in report properties to get what you want, or something very close to it.

 But if not and you get stuck, just holler and we will figure something out.

Jim.
0
Progold S.p.A.IT ManagerAuthor Commented:
thank you, I'll remove the subreports as you suggest. I think it's not a problem

Silvia
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
Column

From novice to tech pro — start learning today.