Report/Subreport with columns

[Tim Stephens]

I have a report based on one table with a subreport based
on a second table. The subreport displays the records
from the second table in to columns. Everything works
fine until the number of records from the second table is
greater than 36 (18 rows for each column). Any records
after the 36th is not displayed at all. If I set the Can
Grow property of the subreport to yes, all of the records
are displayed but I lose the column formating. Does
anyone have a suggestion as to how I can solve this
problem.

Thanks,
Tim

 

[Rick Brandt]

Thanks for the suggestion, unfortunatly I have to use Down
than Across. If I set Can Grow to No, Access doesn't
display any records past the 36th. Why doesn't it just
display those records on a new page?

Because the subreport will not span pages unless CanGrow is true.