Solved

Multi-Column Sub Report

Posted on 2014-01-30
6
468 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
  • 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 34

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 34

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 34

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 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

24 Experts available now in Live!

Get 1:1 Help Now