Subreport formatting

[chris_bro1]

I have a subreport that was intended to return at most 5 rows of data
but can now sometimes return 5-10. As I don't have enough vertical
room to work with, would it be possible to wrap the data in columns of
5 records apiece on the current subreport? ex:

instead of:

field1 field2 field3
elem1 elem1 elem1
..... ....... ......
..... ....... ......
elem9 elem9 elem9

this:

field1 field2 field3 field1 field2 field3
elem1 elem1 elem1 elem6 elem6 elem6
..... ....... ...... .... ....... ......
..... ....... ...... .... ....... ......
elem5 elem5 elem5 elem9 elem9 elem9

or will I just have to modify the current sub report to only pull the
top 5 items and create a second subreport that pulls the remaining
records?

Thanks in advance!
CB

 

[Duane Hookom]

You can set your subreport control height to match 5 records and don't allow
it to grow. Set the subreport's Page Setup to multiple columns to get the
records to wrap to the second column.