Report Setup

[Karen]

I am trying to create an invoice that looks similar to the Peachtree
invoice. I set up the page header and detail, but I can't figure out
how to make the totals print at the bottom of the page. I placed the
sum formulas in the report footer, but it prints right below the
detail. I tried dragging it down with alot of empty space between the
detail and the footer, but then when there are several rows of detail,
the footer rolls to a second page.

How do I set where the footer prints? or am I putting the sum info in
the wrong place?

Thanks.

Rosy

[fredg]

Re: Report Setup

On 29 Jun 2004 09:00:14 -0700, Karen wrote:
[color=blue]
> I am trying to create an invoice that looks similar to the Peachtree
> invoice. I set up the page header and detail, but I can't figure out
> how to make the totals print at the bottom of the page. I placed the
> sum formulas in the report footer, but it prints right below the
> detail. I tried dragging it down with alot of empty space between the
> detail and the footer, but then when there are several rows of detail,
> the footer rolls to a second page.
>
> How do I set where the footer prints? or am I putting the sum info in
> the wrong place?
>
> Thanks.
>
> Rosy[/color]

You can place the totals in the Page Footer, which always prints at
the bottom of the page. But there is a 'trick' to do it.

Read Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.