Grouping footers with detailed info

G

Guest

I have a report that has 2 columns. My footer does not stay with the detailed
info it goes to the nest column or page. I want the footer to say with the
detailed info. I have tryed grouping together. Can anyone help?
 
M

Marshall Barton

Lisa said:
I have a report that has 2 columns. My footer does not stay with the detailed
info it goes to the nest column or page. I want the footer to say with the
detailed info. I have tryed grouping together. Can anyone help?


Is "my footer" the report footer section? If so, it should
span across the page, not in a column.

You can use a group footer to simulate a summary for the
report and be in a column after the last detail. Just
create a new top level group (with footer) based on any
constant expression such as =1 or ="Pseudo Report Footer"
Then move all the controls you have in the report footer to
the new group footer.
 
G

Guest

My summary is not in the report footer it is in my ID footer. I want the
totals to be with the detailed info in the report. Right now I have 2 columns
and some of my totals go over to the next column. I want all of the info to
go to the next column so it says together.
 
M

Marshall Barton

Lisa said:
My summary is not in the report footer it is in my ID footer. I want the
totals to be with the detailed info in the report. Right now I have 2 columns
and some of my totals go over to the next column. I want all of the info to
go to the next column so it says together.


That's not possible if there are more details than can fit
in a column. If they can fit, you can get that effect by
setting the **group** KeepTogether property to Whole Group
(in the Sorting and Grouping window).
 
G

Guest

I did that already and still does not work. Do you know of any other way to
keep details and footers together?
 
M

Marshall Barton

Lisa said:
I did that already and still does not work. Do you know of any other way to
keep details and footers together?


Double check that you have the group footer section's
ForceNewPage and NewRowOrCol properties set to None.

Beyond that, the only reason I can think of is that the
footer has a significant amount of blank space in its
design.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top