Footer Report

hydhart

Hi,

I have a report with 3 pages in NAV 2016 and create this report using SQL Report Builder. I have set footer to print only in last page, but why the footer are also print at page 2? is it bug? if i only have 2 pages, it's worked well. How do I solve this?

Thanks

RockWithNAV

You can put a visible condition as if globals!page number = totals!page number then print. it will solve your case

postsaurav

Hi,
You can bind all the textbox (controls) inside a rectangle in the footer.

Then you can specify the expression which @RockWithNAV suggested in the Visibility of Rectangle.

And that is what @Sowkarthika & @binilabraham are suggesting on a standard Report, but that is an NA version Report.

Sowkarthika

Hi,

Are you dynamically hiding Page Footer? What expression are you using ?

binilabraham

Please take a look at the standard NAV reports (like 10074) which uses a solution to print footer only at last pages.
Else try to use a visibility condition with the help of a developer on footer controls to hide it dynamically based on the TotalPages.

hydhart

Thank you all for your respond,

No, i just set this on Footer Properties. In footer Properties there are only option to check if you want to print this footer on first or last page only.

What Version are you using binilabraham? I can't found any standard report with ID 10074. How can I set dynamically based on TotalPages?

RockWithNAV

You can put a visible condition as if globals!page number = totals!page number then print. it will solve your case

hydhart

thanks RockWithNAV,

can you spesifically show where I have to put that code? Sorry I'm a little confused here.

postsaurav

Hi,
You can bind all the textbox (controls) inside a rectangle in the footer.

Then you can specify the expression which @RockWithNAV suggested in the Visibility of Rectangle.

And that is what @Sowkarthika & @binilabraham are suggesting on a standard Report, but that is an NA version Report.

binilabraham

You can try the way @Saurav and @RockWithNAV suggested. Bind all the controls inside a rectangle and set the visibility condition as RockWithNAV suggested. Please note, before setting up the condition, change the 'RestPageNumber' property to TRUE in the parent group which you used for Page Break.

hydhart

Thanks all for your answers.