Hi Tim,
Thanks for your advice. However, that does not solve the problem of my 2
tables having different lengths. Their subtotals rows (repeated on every
page) should be on the same line.
like this:
---------------------------------------------
cost desc amount tax desc amount
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx
xxx xxx xxxx
---------------------------------------------
subtotal: xxxx subtotal: xxx
where the 2 tables are separate data regions.
NOT like this
---------------------------------------------
cost desc amount tax desc amount
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx xxx xxx xxx
xxx xxx xxxx ----------------------
xxx xxx xxxx subtotal: xxx
---------------------
subtotal: xxxx
Regards,
PM
[quoted text, click to view] "Tim Dot NoSpam" wrote:
> Try setting the bottom margin to force the page break.
>
> "PacMan" <PacMan@discussions.microsoft.com> wrote in message
> news:3C2B22FE-BFFA-483B-8CFE-74D73FA721DE@microsoft.com...
> > Hi,
> >
> > I am having a problem with my report. I would like to display this way
> >
> > --------------------------------------------------------------------------------------------------
> >
> > <Main Report>
> >
> > Employee Name: XXX Employee Address: xxxx
> >
> > ---------------------------------------------------------------------------------------------
> >
> > <Subreport consisting of 2 tables>
> >
> > Code / Description / Amount ! Code / Description /
> > Amount
> >
> > XXX XXXXXXX xxxxxx ! XXX XXXXXXXX
> > xxxxxx
> >
> > XXX XXXXXXX xxxxxx ! XXX XXXXXXXX
> > xxxxxx
> >
> > -----------------------------------------------------------------------------------------------
> > Total xxxx
> > xxxx
> >
> >
> >
> > However, since the data region for the subreport are tables, they almost
> > always do not have the same height. I would like to set a maximum height
> > for
> > the table rows where the rows that will not fit will continue on the next
> > page. Is this possible?
> >
> > In other words, I need to have the table totals exactly on the 6 inch mark
> > of the report. How can I do this?
> >
> > Also, I need to be able to print to a pre-printed form, if I have to
> > (hence
> > the exact positioning)
> >
> > Thanks for your help.
> >
> > Regards
> >
>
>