Footer only on the last page

[Jalz]

Hi Guys,

Have any of you got a slick method of printing data out in the footer of the last page in the report.

I have for example a 3 page orderlines report, and on the final page, I want to place some text & a total in the footer - what I need is "Final Footer" part in the report which does exactly what Title Footer does but at the end of the report.

Thanks

[Inky Phil]

I believe a trailing Grand summary layout part might do what you want

Phil

[Jalz]

Hi Phil,

I've tried this, although this does print on the last page, it doesn't print at the bottom of the page. It only prints at the end of the last record, and I may only have one line on page 3 displaying - and my totals box floating towards the top.

The only solution to this is, in my opinion is to create another layout just for the last page, but its so messy.

[comment]

You cannot have a conditional footer - but you CAN have conditional data in the footer. Define an unstored calculation field (result is text) =

Case ( Get ( RecordNumber ) = Get ( FoundCount ) ; "whatever you want" )

and place this field in the footer. Note that the footer must be high enough to accomodate this data, and this will of course affect all pages - not just the last one.

[Jalz]

Thanks Comment,

That did the trick. I hope in the next version of FM, they improve the reporting capabilities.

Jalz

[sal88]

Or, to possibly save making new fields, and to be able to have graphics on the footer, eg seperating lines for total/sub total etc:

Create 2 global container fields, placing a blank white image in one of them and leaving the other empty. Then create a calculation field like comment said, but with the instance of it being the last page showing the 'transparent' field otherwise show the 'white image' field.

Then simply place this calculation field over whatever you place in the footer part, and what is beneath it will only show on the last page.

[kanedsista]

Case ( Get ( RecordNumber ) = Get ( FoundCount ) ; "whatever you want" )

Is that the exact calc you need to use (apart from inside the "")? Coz I can't get it to work.