Horizontally expand child crosstab queries in a report

[Guest]

I have an unbound report that contains 4 child crosstab queries, each showing
the days of the month accross the top of the queries. These queries expand
by 1 day each business day. However, the child objects (querries) in the
report have fixed widths that do not expand dynamically when data is added.
Currently, I have to manually expand the child objects and force the report
to be 2 pages wide regardless of how many days into the month we are, meaning
the second page blank for half of the month. Does anyone know a work around?

 

[Duane Hookom]

There are some sample crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The Crosstab.mdb has a
report that "wraps" extra columns.

 

[Guest]

Thanks Duane and yes, I did check that sample out. I will probably end up
using the solution you suggest. However it just seems like a simple thing to
be able to do - expand a child object on a report when the underlying data
that expands. Thanks.