How do we get a subreport to display two columns?

[jt463]

We have three reports we are trying to trying to combine into one report. Everything is working great (one large report and two subreports) with one exception.

One of our reports has a width of 4", which - by itself - will expand to a second column if the data requires. Unfortunately, as a subreport it will only expand vertically rather than to a second column.

I have kept the same settings as the report has by itself. I have expanded the width, reduced the width, but all to no avail. I cannot figure out how to force the subreport to expand to a second column - if need be.

Thank you in advance!

 

[dhookom]

Subreports can display multiple columns quite easily if they are set to display Across Then Down. Setting to Down Then Across would require the subreport to understand Page information which it can't.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]