Report/Subreport with columns

  • Thread starter Thread starter Tim Stephens
  • Start date Start date
T

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
 
Tim Stephens said:
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?
Click to expand...

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