Multi-column subreports - down then across

[Guest]

Hi,

I'm trying to create a subreport that lists the entries down and then across
for a few reasons. The primary reason is I want the items to be listed
alphabetically going down and then across (to match a previously made paper
form). Also, the space is limited vertically that the subreport can fill so
I wanted to set the height property under the column size. However, when I
do all of the above, the subreport only comes out in one column. I can get
the multiple columns if I do the "Across then Down", but then the items are
not in the correct order. Any ideas? Thanks for the help.

 

[Rick Brandt]

Hi,

I'm trying to create a subreport that lists the entries down and then
across for a few reasons. The primary reason is I want the items to
be listed alphabetically going down and then across (to match a
previously made paper form). Also, the space is limited vertically
that the subreport can fill so I wanted to set the height property
under the column size. However, when I do all of the above, the
subreport only comes out in one column. I can get the multiple
columns if I do the "Across then Down", but then the items are not in
the correct order. Any ideas? Thanks for the help.

You cannot use Down, Then Across in a subreport that also has CanGrow set to Yes
on the subreport control. The subreport does not "know" when the parent report
has hit the bottom of a page and that is why you get one continuous column. It
does know when it has hit the bottom of the subform control (if CanGrow = No).