Report Footer Printing On Separate Page

[huertalm]

I have a multiple column report and the report footer is printing the "totals" column on a separate page. i have the page header set to "all". any ideas on what can be causing this and how i can fix it?

 

[llkhoutx]

You report page, including the margins, is larger than the printed page size. Common problem in designing reports.

 

[huertalm]

Fix

So should i make the report with less columns, change the width, or change the height? my report footer does not print horizontally. it prints vertically like a column. if, for example, my report has 7 columns, 5 will print on the first page, two on the second and the total column will print on the last page. i know there is room to print the total column on the second page because the first page has 5 columns, the second only two. is this still because of the report size? thanks

 

[llkhoutx]

Adjust the margins first, especially the right and bottom margins, as they have the least effect on how your actual report looks.

 

[huertalm]

i have all my margins set to .25 except the bottom. it is .5. that is the lowest it will allow me to go. it is still printing the footer on a separate page

 

[casey]

Could you try putting the [totals] field in the page footer instead?

Also try setting the CanGrow, CanShrink = true for the larger controls in the details sections(if any exist that is).

Just a few thoughts.

 

[huertalm]

in the page footer section i have the "area" totals. in the report footer section is the "grand" total. ive already tried moving the area totals to the detail section and the grand total to the page footer section but this throws the report way off. ive also already tried the "cangrow/shrink" option. thanks anyway

 

[Rich]

Article ID: Q119783

.

 

[llkhoutx]

If you're still having trouble, post your report and it recordsource tables/queries in an mdb.

 

[huertalm]

actually i know exactly what is wrong with the report i just cant fix it. my report is in landscape and switching it back to portrait is not an option. although i do not have the detail section of my report visible the group footer is too long and so is the report footer. they are each about 6.5 inches. when i run the report the report footer tries to print directly below the group footer but since there is not enough room it forces it on to a new page. is there any way i can have the report footer start a new column right after the group footer without trying to print the report footer below it. I have already tried the "force new column" option on the report footer. thanks

 

[huertalm]

FIXED

I just added another group footer for the same field and changed the 'group on' property to "prefix characters" and the 'interval' property to "1". works like a charm. now we know.