How to display field in footer, only on last page

building reports crystal reports
1

I am using the footer with page numbering on every page.

But, I want an additional field to dispaly in the footer also, but only on the last page.

How to do?

Oh, I don’t want to put that additional field in the Report footer, because I want it to align veritcally with the page numbering.

Brian

kappbr (BOB member since 2009-01-28)

2

You can use the following formula:


=If(Page() = NumberOfPages();"insert your text or variable here")

RGeurts :uk: (BOB member since 2006-12-29)

3

Using NumOfPages will slow your report down as it has to render all of the pages before it can calculate that value.

So, you have two options. You could change the formula to something like the following:

If OnLastRecord then {MyTable.MyField}

Or, you could just put the field in the page footer where you want it. Then right-click, go to Format Field, click on the formula button to the right of the Suppress checkbox (do NOT check the checkbox!) and enter the following formula:

not OnLastRecord

This will suppress the field unless you’re on the last record.

-Dell

hilfy :us: (BOB member since 2007-04-16)

4

Hai Put that field at the report footer then you will get in only last page

vasanece (BOB member since 2012-08-16)