"Pages breaks" when I add a page footer to the report

i have a report that calls several subreports. I had everything working fine
until I added a page footer to the main report. All I put in it was a small
textbox that is going to hold page numbers...
Anybody know why its page breaking? I hope it has nothing to do with the
implicit keep together when calling subreports...
Let me know if anybody has any ideas.. I've tried many things an nothing
works..
JoshuaThe length of the page exceeds the page size so it "page breaks" so try
checking the length of the page and the page you selected say A4 former
should be always less than later otherwise page break occurs.
Amarnath
"gdjoshua" wrote:
> i have a report that calls several subreports. I had everything working fine
> until I added a page footer to the main report. All I put in it was a small
> textbox that is going to hold page numbers...
> Anybody know why its page breaking? I hope it has nothing to do with the
> implicit keep together when calling subreports...
> Let me know if anybody has any ideas.. I've tried many things an nothing
> works..
> Joshua|||Not quite sure I understand what your saying... My main report in the
designer fits within the margins I have set up...
Explain further...
"Amarnath" wrote:
> The length of the page exceeds the page size so it "page breaks" so try
> checking the length of the page and the page you selected say A4 former
> should be always less than later otherwise page break occurs.
> Amarnath
> "gdjoshua" wrote:
> > i have a report that calls several subreports. I had everything working fine
> > until I added a page footer to the main report. All I put in it was a small
> > textbox that is going to hold page numbers...
> >
> > Anybody know why its page breaking? I hope it has nothing to do with the
> > implicit keep together when calling subreports...
> >
> > Let me know if anybody has any ideas.. I've tried many things an nothing
> > works..
> >
> > Joshua

"colspan" functionality in a table?

I want to display a label and some column totals in the footer of a table. The label text is wider than any column in my table. Is there some way to tell a table column that I want it to span more than one column? I do not want the footer column to expand because it causes the whole table column to expand.

The Sum function is only valid within the body section so I cannot move the totals to the page or report footer. I cannot make them seperate text boxes from the table since it expands and I want them at the bottom without any seperation.

The only solution I could come up with is to make a subreport with the same query, just totals, and put it after the first. This offends my sense of esthetics. There has to be a more elegant solution.

TIASelect the multiple columns, right click, and choose Merge Cells.