printing subreports side-by-side

[jpatti]

I have a main report with two subreports in the details section in a horizontal spacing with tops aligned. When I preview the report, it shows one on the left and one on the right correctly, but the second subreport is bneath the first one.

How can I get these to print side-by-side? Basically, I want my two subreports to appear like two tables next to each other rather than beneath one another.

 

[WildHare]

When I preview the report, it shows one on the left and one on the right correctly, but the second subreport is bneath the first one.

Well, which is it? Is one on the left and one on the right, or is one below the other?

Make sure your page width/margins are all correct. Sometimes the preview mode shows things correctly, because you have the margins set, but then when you go to print, the printer OVERRIDES the margin and sets it differently, because it can not print that wide - in other words, you might have set the left/right margins to .25" , but the printer can't print any wider than .50" margins - so things get fouled up.

What you are trying to do DOES work - I've done it in the past many times. You just have to make sure the subreports are placed correctly and everything else falls in to place.

Jim
Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[jpatti]

Perhaps I need to explain this better.

Each of the subreports is about 1/3rd of the printing area in width.

It's not a margin issue as the report and page headers and footers are wider than the combined width of the subreports and they print on a page fine in both preview mode and actual printing.

The first subreport prints in the upper left, the second prints in he lower midarea, both below and to the right of the first, like this:

subreport1
subreport2
page and report headers extend out to here

I have no idea why they won't print like this which is what I want:

subreport1 subreport2
page and report headers extend out to here

The main report is bound to a query with a single recordset. The subreports contain unrelated data and thus have no child/master links to the main report (as they are based on unrelated queries). There is no grouping or sorting in the main or subreports. Since the main report has one record, the subreports, which are located in the details section appear once. They just don't appear next to each other even after aligning tops, setting the size on the subreports themselves as well as their contianers in the main report, and all sorts of playing around with can grow and can shrink properties on the subreports, the Details section, etc.

I spent quite a number of hours playing with this last night. If I move the subreports to the page header section, they print properly. Unfortunately, the page header section cannot be set to have a dynamic height, and since the subreports length can vary, this is not a solution. I also noticed that the totals in the report footer (grabbed from the subreports which have a total field with visible set to No) don't work except with the subreports in the details section.

I'm frustrated with this. It seems a rather simple report to have spent this much time on!

 

[WildHare]

If it is possible, feel free to send me a quick copy of this guy - this should be a simple thing, I'm just wondering if there is some other, extra-Report problem.

Send it to my work email - jhare@harrahs.acs.com

Otherwise, I'm not sure what the problem is - it looks as though you've exhausted all normal channels. The only other thing I can think of is to perhaps use invisible boxes on top of/next to the subreport controls to force the positioning somehow.

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm