Report page and summary totals

[Dirgio]

I have designed a report that I would like to display totals at the bottom of each page and a summary at the end. The problem is on the last page the summary prints at the end of the data and the page total still prints at the bottom. Is there a way to not have this page total print at the bottom of the last page. I have been experimenting with some print when's but until now have been unsuccessful. Thanx,

 

[jimstarr]

Hi Dirgio,

It sounds like you have your page totals in the "page footer" band and the summary totals in a separate "report summary" band. The problem is, as you point out, the "page footer" will always print at the bottom.

One way to handle this is to move all the summary stuff out of the "report summary" and into the page footer, after the page totals. In each summary element set the "print when" to "RECNO() = RECCOUNT()". That way it will print only at the end.

Jim

 

[ramani]

1. In the page total.. Print When. ... !EOF()

OR

2. If for any reason, you aer not likely to be at EOF() when the report ends... then you can conside doing this...
a. In your calling programe, have a Public variable
IsPageEnded with a default value .f.
and a method
MyPageEnd
m.IsPageEnded=.t.
RETURN .t.
b. Print Page Total When IsPageEnded = .f.
c. At the beginning of report set IsPageEnded = .t.
d. Print Summary When MyPageEnded() which will set the value for not printing last page totals.

Hope this idea works for you. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com