Problems with Total in Footer

[IplayWoW]

I'm trying to do something like OP in http://www.fmforums.com/forum/showtopic.php?tid/179306/

What I'm trying to do is have a footer that appears at the end of every page. I want the footer to contain a "Comments" field as well Total$Amount.

I want the "Comment" field to appear on every page but I want the Total$Amount ONLY to appear on the last page.

Like the previous post, I'm trying to make a container with a white image and another as transparent. On a 3 page order, for example, the white image is over "EX_sLineTotal" on pages 1 and 2. However, on page 3, it is transparent and the "EX_sLineTotal" is visible.

I'm having NO success. Any help?

Please see attached picture.

http://img710.imageshack.us/img710/2231/picture3ul.png

Edited December 21, 2009 by Guest
Spelling

[bruceR]

Don't use an overlay image. Just use conditional formatting. Your script would set $$last_page to the page number of the last page. Conditional format the text to use this. So you could set default text for the field to white, then use case( get( PageNumber ) = $$last_page; 1) and turn it black.

[IplayWoW]

Wow... so much easier. Didn't even think of that

Thanks a ton. Let me give it a shot and see if I can get it to work.

Edited December 21, 2009 by Guest

[IplayWoW]

I can't quite seem to get it to work.

Can you be a little bit more specific?

I'm still learning and need someone to hold my hand. Haha

I defaulted the text to white (as you said) and set the Conditional Formating to black using:

case( get( PageNumber ) = $$last_page; 1

What am I doing wrong?

Edited December 21, 2009 by Guest

[IplayWoW]

Bump

[bcooney]

Did you set $$lastpage? You'll need to Enter Preview, Go to Page Last, set $$lastpage to get (pagenumber).

[comment]

Why is a $$lastPage necessary?

[bcooney]

For the conditional formatting that Bruce suggested.

[comment]

Did you look at the thread mentioned in the OP?

[bcooney]

Um, no. So, maybe I should leave it to you. By all means...

[comment]

I already did - in the other thread. It was before conditional formatting, but the idea is the same.

[IplayWoW]

I took the suggestion of using $$last_page and conditional formatting to Case ( Get (Pagenumber) = $$last_page; 1)

I got it to work... sort of...

I set the default text to white and the conditional formatting to black but for some reason the Black Formatting is appearing on the FIRST page and not the subsequent pages (or last page as intended).

I double checked my script and I do infact have "Go to Page/Record" (Last) and not (First)

I can't figure it out

Also, Just to make sure $$last_page was getting set to Page "X", I included the field in the layout. The field is getting correctly. For example, in a 2 page report, $$last_page is getting set to "2".

The WEIRD thing is, even on the printable report, the $$last_page field will only display on page 1... and this field has NO CONDITIONAL FORMATTING on it. Any explanation for that?

EDIT:

RAAAAGE... As I said earlier I'm a newbie and I need someone to hold my hand. I made the stupid mistake of not having $$last_page as a Global Field (reason for not appearing on subsequent pages). I think I may have figured it out

Edited December 22, 2009 by Guest

[bcooney]

$$last_page is not a field of any type, it is a global variable. To set it, you must be in Preview Mode, go to page Last, then set it.