Rendering Subreport w/Columns?

[(PeteCresswell)]

I've got a subreport where the Report.PageSetup specifies
columns, but when it renders on the parent report, the columns
are not implemented.

viz: http://tinyurl.com/29pywn8

Is that functionality not available in a subreport or am I doing
something wrong?


Tangentially, it would be nice if I could make the enclosing
option box expand with the size of the subreport. I guess that
can be done within the subreport by writing some code, but is
there an object or something that will do that automagically?

 

[John Spencer]

In a subreport Across then Down for columns works, but Down then Across does
not "work".

The reason is that as a sub-report the report object has no way to determine
when it has reached the end of the page and therefore does not know when to
start the next column. The main report is the one that handles paging, etc.

If you are using Across then Down then post back. That should work.

I've got a subreport where the Report.PageSetup specifies
columns, but when it renders on the parent report, the columns
are not implemented.

viz: http://tinyurl.com/29pywn8

Is that functionality not available in a subreport or am I doing
something wrong?


Tangentially, it would be nice if I could make the enclosing
option box expand with the size of the subreport. I guess that
can be done within the subreport by writing some code, but is
there an object or something that will do that automagically?

--

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[(PeteCresswell)]

Per John Spencer:

If you are using Across then Down then post back. That should work.

Bingo!

Worked a-ok.

Thanks!