Re: Horizontally expand child crosstab queries in a report

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

"Duane Hookom" wrote:

> 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.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Kid Jones" <KidJones@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:92497306-9EEE-495C-8F44-A71920F605E2@xxxxxxxxxxxxxxxx
> >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?
>
>
>
.

Relevant Pages

  • Re: Report Filters
    ... Thanks Duane for publishing your tool. ... users can create queries and somewhat formatted reports on the fly without ... > little knowledge of the tables and relationships to create and run queries. ... > It is not designed to be used as the record source of a published report. ...
    (microsoft.public.access.reports)
  • Horizontally expand child crosstab queries in a report
    ... I have an unbound report that contains 4 child crosstab queries, ... report have fixed widths that do not expand dynamically when data is added. ...
    (microsoft.public.access.reports)
  • Re: Report With Sub Reports VERY SLOW
    ... are returning multiple values per date per employee. ... >> There are some general tips on making sure reports and queries run faster ... >>>I have a schedule report that I have built that runs too slow (usually ... >>> reports can expand as needed and for formatting). ...
    (microsoft.public.access.reports)
  • Re: Report With Sub Reports VERY SLOW
    ... I am trying to take employee ... slow because I use 14 subreports. ... > There are some general tips on making sure reports and queries run faster ... >> reports can expand as needed and for formatting). ...
    (microsoft.public.access.reports)
  • Re: 1 for the gurus & MVPs
    ... I created the 2 queries: ... report as opposed to another contractor who 50+ jobs in a month, ... > as my subreport. ... > Thx again Duane, very helpful. ...
    (microsoft.public.access.reports)