Solved

Multi-Column Sub Report

Posted on 2014-01-30
6
503 Views
Last Modified: 2014-02-25
I need to create a subreport (the second of two in the detail section) that contains four columns.  I want to use the down/across option.  

So far, the subreport will not create four columns.  It creates only one UNLESS I change the CanGrow property of the subreport control to No to limit its size to what I have actually drawn on the detail section.  The problem with this is that Access limits the number of records that are displayed and will not produce additional pages.  So if I set the height to accommodate 6 rows by 4 columns, I see 24 records.  But if the client has 25, I'm SOL so that doesn't work.  I tried changing to the across then down which does produce the four columns and will paginate correctly but it confuses the user.  He has been using a FoxPro report for 15 years and doesn't want to change how it looks.

Does anyone have any ideas for another alternative?  I was thinking about trying to use Excel but my head started spinning.  I might give it a whirl if I had only the one subreport but I have two so getting it to populate correctly is well beyond my ability to automate Excel.
rpt.JPG
rptFaceSheet.pdf
rptFaceSheetAccrossThenDown.pdf
0
Comment
Question by:PatHartman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 57
ID: 39822463
<<Does anyone have any ideas for another alternative? >>

I have an idea, but I want to understand the requirement first.

So the current report runs down the first column till it hits the bottom of the page, then goes to the second column, down to the bottom, then 3rd, 4th, and then flips to a new page if it needs more?

Jim.
0
 
LVL 36

Author Comment

by:PatHartman
ID: 39822508
What I want is down and over:
1  5  9  13
2  6 10  14
3  7  11 15
4  8 12 16
What I get is:
1
2
3
4
5
6
7
8
9
.....

I can get down and over to work but ONLY if I set the CanGrow property of the subform to No.  But that has a nasty side effect in that once I choose a size, any records that don't fit are discarded.  The subform will NOT continue on the next page.
What I CAN get if I choose over and across
1 2 3 4
5 6 7 8
9 10 11 12
13 14 15 16
This last option at least gets me the four columns and it paginates correctly but it is confusing to the users since the FoxPro report they have been working with for 15 years works like example 1.

The above examples show 16 records.  I have clients with as many as 150 so the subform MUST grow and paginate correctly.
0
 
LVL 57
ID: 39822607
Pat,

 I don't have anything handy to check this with right now, but make the following changes and then see if the down and across setting works as it should:

1. Make the page footer visible and make very thin.
2. Un-check the "Same as detail" in the page setup.

 Not sure if that will work or not; sub-reports are such odd ducks.

 I've got a couple more things I want to try here, but give that a shot first.

Jim.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 36

Accepted Solution

by:
PatHartman earned 0 total points
ID: 39836850
Hi Jim,
That didn't work either.  So far the only thing that will make the down then across function the way I think it should is to change the can shrink/can grow properties of the subreport to no.  But, that isn't a viable solution since it truncates the data that won't fit in the window.

I wouldn't spend any more time on this unless you want to solve this for yourself.  I'm going to set the report to across then down and hope the users can learn to live with it.

Thanks for your help.
Pat
0
 
LVL 57
ID: 39839687
<<I wouldn't spend any more time on this unless you want to solve this for yourself. >>

 I like the odd problems.  Let me see what I can come up with.

Jim.
0
 
LVL 36

Author Closing Comment

by:PatHartman
ID: 39885090
This appears to be a bug in the reporting engine.  There isn't a suitable solution that I have found as yet.  I ended up using the across-then-down option of ordering the items in the subform.  This is awkward but the users will ultimately get used to it.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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