Horizontally expand child crosstab queries in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kid Jones - 21 Jun 2005 22:49 GMT

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?

Reply to this Message

Duane Hookom - 22 Jun 2005 00:45 GMT

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.

Signature

Duane Hookom
MS Access MVP

>I have an unbound report that contains 4 child crosstab queries, each
>showing
[quoted text clipped - 9 lines]
> the second page blank for half of the month. Does anyone know a work
> around?

Reply to this Message

Kid Jones - 23 Jun 2005 22:00 GMT

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.

> There are some sample crosstab reports at
> http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The Crosstab.mdb has a
[quoted text clipped - 13 lines]
> > the second page blank for half of the month. Does anyone know a work
> > around?

Reply to this Message