Getting Columns to Wrap in a subreport

I'm trying to create a report that prints a deposit ticket for the bank.  I have 2 tables.  The first is a table containing all the totals (checks and cash) that are being deposited on the ticket.  The second is a listing of the ammount of each check being depositted.  So I created a report that puts the information from the first table on to the top portion of the deposit ticket, then I created a subreport to dsiplay the amount of each check at the bottom of the deposit ticket.

I set up the subreport to use 6 columns going down and then accross, and if I open up this subreport by itself it works fine, the check amounts wrap to the next column when they get to the bottom of the page.  However, when I open up the main report which contains the subreport in its detail section, the check amounts get the bottom of the page and then go onto the next page.  Does anyone know how I can fix this?


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.


set the "CanGrow" property of the according fields to true.
Also set the "CanGrow" of the sections to true and check the "KeepTogether" property of the section


valencehealthAuthor Commented:
Those are already all checked to true
Try moving the subreport to the header or footer.
Ultimate Tool Kit for Technology Solution Provider

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

valencehealthAuthor Commented:
I just tried that and that didn't work either.
I will post a notice in the "experts message question" to see if anyone else has an idea.

For columns to work, the engine needs to know the page length, quite obviously. For subreports, it hence needs to know the size of the control. If you use "can grow", the virtual page length of the subreport is infinite. So you can only have columns in a subreport if the subreport control has a fixed length *without* the CanGrow property.

You might want to say "use the remaining available space, please", but I don't know of a way to specify that.


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
valencehealthAuthor Commented:
I took off the can grow and can shrink and made the size of it to be the bottom 2/3 of the page and its working fine now.  Now I assume that if the data fills up all 6 columns then the second page will only be using 2/3 of the page as well.  If there is an easy way of fixing this so that subsequent pages use the full page that would be great, if not this shouldn't be too big of a deal.
Change the size of the section in the on format event of the page header section.  Add a control with a contorl source of "=page".  Let's call it "txtPageNumber".  Then in the on format event of the page header section put:
Private Sub Header_Format(Cancel As Integer, FormatCount As Integer)
If txtPageNumber > 2 Then Detail.Height = some number in twips
End Sub

twips = 1440/inch
> Now I assume that if the data fills up all 6 columns then the second page will only be using 2/3 of the page as well.

Sorry, but that assumption is wrong. There will be no second page. The data that does not fit will simply not be shown.

If your top portion of the report is also columnar, I see no easy solution. If not, consider doing it the other way around: use the main report for the columnar output and rewrite the top portion of the first page as a subreport in the report header.

If both portions are columnar, I think you will have to generate the report in a text processor and not in Access, but that is of course much more complex.

Good luck!
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.