Creating reports and dashboards | Stimulsoft community forum

Hello,

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

Thanx,
René

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.

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é

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.

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é

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

Yes that is what I mean. Is that possible?

Greetings René

In Monday it will be available.

Thank you.

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

René

We will try!