Formatting subreport and Microsoft Article KB208364

[Tony Williams]

I have a two column subreport that I would like to print Down then Across.
The Microsoft site Knowledge article KB208364 recognises this as a problem
and suggests you use Across then Down but this makes the report less clear
in my particular case. Does anyone have a work round?
TIA
Tony Williams

 

[Marshall Barton]

I have a two column subreport that I would like to print Down then Across.
The Microsoft site Knowledge article KB208364 recognises this as a problem
and suggests you use Across then Down but this makes the report less clear
in my particular case. Does anyone have a work round?

Nothing simple. Since page boundaries are in the realm of
the main report, the subreport has no idea when the down
then across should start a new column.

The only clunky idea that comes to mind is if your subreport
is guaranteed to fit on one page. In this case, you can use
the subreport's record source query to calculate each
record's column (using a ranking type subquery) and then the
sort the subreport by the calculated column number.

Really yucky, but you might be able to adapt some of the
previously posted examples. Try searching the google
archives for this newsgroup to see what you can find.

 

[Tony Williams]

Thanks Marsh I'll have a look around
Tony

Nothing simple. Since page boundaries are in the realm of
the main report, the subreport has no idea when the down
then across should start a new column.

The only clunky idea that comes to mind is if your subreport
is guaranteed to fit on one page. In this case, you can use
the subreport's record source query to calculate each
record's column (using a ranking type subquery) and then the
sort the subreport by the calculated column number.

Really yucky, but you might be able to adapt some of the
previously posted examples. Try searching the google
archives for this newsgroup to see what you can find.