ReportSummary at bottom

[René van den Berg]

Hello,

For a customer I need to put the invoicetotal on the bottom of the final page. How do I do that?

Thanx,
René

[Vital]

1. Add to your report FooterBand.
2. Set property FooterBand.PrintOnAllPages to false
3. Set property FooterBand.PrintAtBottom to true
4. Place on FooterBand textbox.
5. In textbox type your aggregate function, for example: {Sum(Products.Amount)}

Thank you.

[René van den Berg]

Hi Vital,

I tried your solution but it only works on reports which have 1 databand. My invoice report needs to have to databands. The structure is Invoice -> Orders -> Orderlines. What happens if I set the footer as you proposed is that after every Order I get a FooterBand and the final Footerband prints at the bottom. What I want is 1 FooterBand on the bottom of the last page. Is there any other way I can do this? I tried to add a PageFooterBand and only make it visible at the last page (via the OnBeforePrint event), but I didn't succeed because there is no way in determining the last page. Please help.

Thanks in advance,
René

[Vital]

You can use property PrintOn of text (from version 2006.4). Place on PageFooterBand text and set property PrintOn of text to OnlyLastPage.

Thank you.

[René van den Berg]

Thanks will try that. Just one question: why not make a property on the ReportSummaryBand to print on the last page? I would make it more intuitive.

Greetings,
René

[Edward]

Did you mean PrintAtBottom property of the SummaryBand?
Thank you.

[René van den Berg]

Yes that is what I mean. Is that possible?

Greetings René

[Vital]

In Monday it will be available.

Thank you.

[René van den Berg]

Great! Thanks.
Don't work too hard in the weekend :grinder:

René

[Vital]

We will try!