Subreports with Columns (XP Sp2)

Topic

New Reply

G’day All

I have a subreport (inside a report) which is supposed to layout it’s data in two columns (down then right, as set up in File Pages Setup Columns of the subreport). When I run the subreport outside the main report, I get the two columns whether I have them set down and right or right and down. No Problem.

However when I run it inside the main report, it refuses to wrap into the second column when I have it set down and right, instead generating a new page. If I set the columns in the sub report to right and down it works fine.

Width of the subreport inside the main report is adequate. I’ve played with Grouping and Keep Together properties of the various sections of the reports without success.

Any sugegstions ?

Regards Ken Pascoe

Reply | Quote

Replies

This is a known problem, see ACC2000: Only a Single Column Is Printed in a Subreport with Multiple Columns. Subreports stretch vertically to fit in the available records, so when the subreport is set for printing Down, then Right, it never gets around to creating a second column. Setting it to print Across, then Down is the only workaround given.

Reply | Quote

Is there any new information on this? I have the need to do down and not across in the sub report in Access 2002 SP2.

Thanks,
Marty

Reply | Quote

No, subreports simply don’t work like that. It hasn’t changed in Access 2002 and 2003 and I don’t expect it to change in a next version either.

Reply | Quote

I was wrestling with this problem last week and came up with a solution that may help in some situations. The challenge is to get a multiple column down-then-across subreport to work — as noted in this thread, unless you specify across-then-down, you don’t get the multiple columns — if the content extends past the end of the page, you get one column on the first page and a continuation (still one column) on the second page, etc.). However, things work more as you would expect if you specify across-then-down for the subreport multiple column page layout. Unfortunately, this format often doesn’t work for multiple column report content.

I have found that if you set the Can Grow property to No for the subreport control on the parent report and size the control to fill the physical size of the page (this can be a significant limitation), then the subreport will show multiple columns in the down-then-across format. The significant limitation is that if you have more subreport content than what fits in this fixed-height subreport control, the excess will not be visible. Nonetheless, this may be helpful if you know your content will not exceed one page (with multiple columns).

Reply | Quote