Reports with fixed position elements

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.
RegardsTry 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
>|||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
"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
> >
>
>