I am trying to force the group footers to always show up at the bottom of the last page of the report.
I have used the method 3 in Microsoft support method KB 208979 It works good, the only problem is that there is a gap at the bottom of each page in the size of the footer... and then on the last page it prints the group footer..
Can anyone advise me on how to print pages 1-3 normal (use all the space) then still have the footer show up at the bottom of the last page.
The report that I am building it on can vary from 1 sheet to 10 sheets... so putting it in the page footer will not work. and the if me.page=me.pages ..visible method is very buggy..
Thanks
I have used the method 3 in Microsoft support method KB 208979 It works good, the only problem is that there is a gap at the bottom of each page in the size of the footer... and then on the last page it prints the group footer..
Can anyone advise me on how to print pages 1-3 normal (use all the space) then still have the footer show up at the bottom of the last page.
The report that I am building it on can vary from 1 sheet to 10 sheets... so putting it in the page footer will not work. and the if me.page=me.pages ..visible method is very buggy..
Thanks
