Multiple columns possible on a sub-subreport? 1

[Haccess]

Hi. I have a nested main report, a subreport, and a sub-subreport (think invoice no., line item no., and serial numbers). How do I get the serial numbers sub-subreport formatted with snaking columns so they don't take up so much room on the sheet?

The subreport shows multiple columns in preview, but reverts back to only one column on the parent. I used Page Setup > Columns to format the lowest level report.

Thanks,

Tom

 

[dhookom]

Your columns in a subreport must be set to display Across then Down. If you really want/need them to display Down then Across, you have a lot of work to do.

Down then Across would require the subreport to understand page information. Subreport don't know diddly about pages or page breaks.

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]

 

[Haccess]

That was the ticket. Thanks!