Invoice - Show totals only on last page

[jasonwood]

I'm trying to make it so invoice totals only appear on the last page of the invoice.

I have a field, gLastPageNum, which keeps track of the total number of pages before printing.

I tried putting a calculated container covering the footer with the calculation,

If(Status(CurrentPageNumber) ? gLastPageNum, gWhiteContainer, "")

Where gWhiteContainer is a container in which I pasted a solid white rectangle the size of the footer (which I created in FM).

It's not working. Am I going about this the right way?

[Fitch]

Have you tried using a Trailing Grand Summary part?

[jasonwood]

Problem with that is it doesn't print at the bottom of the page

[-Queue-]

Try Case( Status(CurrentPageNumber) = gLastPageNum, total ).

[jasonwood]

Hmmm... I could do that for each of the fields, but the graphics (lines) would still be there. I can live with that. Is the container trick supposed to work? I thought I had heard of that being done before.

[-Queue-]

Do you mean lines indicating a total below? If so, use the same calculation with a container result and paste your line(s) into the referenced container. I've done this with an insanely dynamic invoice layout where nearly all lines and summaries are calculations based on the data immediately above and below the current record.

I don't know about the container trick, but it seems easier to do the opposite and only show the result when you want to, not to try to hide it otherwise.

[jasonwood]

Okay, thanks for the advice. I was just thinking maybe I forgot to check "Unstored", and I believe that would cause it to fail, so I'll check that tomorrow morning and if not I'll change things around.

Thanks.

[jasonwood]

I noticed the calculated container will show up correctly if I move it up a few pixels so it begins on the body layout - but then it prints behind the text in the footer so as not to cover it up.

Any idea why --If(Status(CurrentPageNumber) ? gLastPageNum, gWhiteContainer, "")-- only evaluates correctly in the body part?

[-Queue-]

I'm assuming ? is <=, which means it would always evaluate as true. Have you tried Case( Status(CurrentPageNumber) <> gLastPageNum, gWhiteContainer )? The default null isn't necessary, nor does it make sense when using a container result.

[jasonwood]

actually the ? was supposed to be a not equal to sign.