Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-10-21 : 12:34:34
|
| Hi!I am modifying a report in ac97. I added a report footer, but I had hard time to make it print with the body of the report on the same page.I also have modified the page footer. I understand that normally is the last piece on any page. I moved every controls (as well as event procedure) from the page footer up to last session/group footer area, then I decreaed the size of the Page Footer by dragging its bottom edge up to its upper edge so that there is no gap in there.. However, when it prints, the report footer is on its own page, even it is small enough to fit in the blank space left on the bottom part of the previous page. Which property/setting that I have to adjust to make it shows in the same page if space is not an issue?I have also tried to set the page footer visible to false, changed the page setup bottom margin from 0.5" to 0.005", tried to delete the old page footer, and messed around with Keep Together settings. But none of it seems to work.Thanks! |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-21 : 13:50:43
|
| When you were using the Page Footer, I believe the Footer appears in the bottom margin, so you have to make sure the bottom margin is large enough to hold it.When you switched to a Group Footer, look for an option to insert a page break before the footer or after the previous group and see if that is causing your trouble. One other option is that you're actually seeing a GRAND TOTAL area and not just the GROUP footer. There should be an option to turn that off in the group properties.---------------------------EmeraldCityDomains.com |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-10-21 : 14:24:47
|
| Thank you! I found it.It is in report property window, under Page Header line. Its value used to = Not with rpt ftr. I changed it to =All Pages. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-10-21 : 14:32:37
|
| Check the "NewPageBefore" setting of the report footer section. make sure it is false. |
|
|
|
|
|
|
|
|
to keep the report footer on the same page