need to view the total on second page if 1st page is full with detail

[rehanemis]

Hi,

i have simple invoice report. i want to show the totals on 1st page if the invoice detail has some products and when products are many then want to show the total on the second page only.

Currently it showing the total on both pages when there are many products on 1st page.

Please check design view of report .

Any suggestion.?

 

[JHB]

Move it from the page footer to the report footer.

 

[rehanemis]

Thanks it works, but it showing the total on 2nd page although there are space on 1st page. It allowing to add more products on 1st page but still showing the total on second page.

I want it to be on next page when first page has no space.

 

[JHB]

Thanks it works, but it showing the total on 2nd page although there are space on 1st page. .

It should be on first page if there is space enough. (Do you have a page break added?)
Could you post a sample database?

 

[rehanemis]

Thanks so much for your help. it has space issue.

 

[JHB]

Thanks so much for your help. it has space issue.

You're welcome, good luck!