Summary VS Footer
Hi.
I know this is probably a dumb question but I really need a better way to
solve my problem that the workaround I'm using right now.
I have a report on which I need a summary band (I want some info to print
ONLY AT THE END of the report). The thing is that when I put labels and
DBtext in the summary band, if the last page of the report is half filled,
the summary will print in the middle of the page. I want it to always get
printed at the bottom of the last page, no matter what.
My workaroung is this one: I put the info I need for summary in the footer
band and put some code in the BeforePrint event so that this info becomes
visible only if the page about to be printed is the last one. I'd really
like to get rid of that code. (In fact, I HAD to get rid of that code and
now all my invoices print with a TOTAL on the bottom of each page!!)
I know the answer is probably stupid (like a property I don't know about or
something I haven't done right) but I really need a solution to this
problem!
Thanks alot!
I know this is probably a dumb question but I really need a better way to
solve my problem that the workaround I'm using right now.
I have a report on which I need a summary band (I want some info to print
ONLY AT THE END of the report). The thing is that when I put labels and
DBtext in the summary band, if the last page of the report is half filled,
the summary will print in the middle of the page. I want it to always get
printed at the bottom of the last page, no matter what.
My workaroung is this one: I put the info I need for summary in the footer
band and put some code in the BeforePrint event so that this info becomes
visible only if the page about to be printed is the last one. I'd really
like to get rid of that code. (In fact, I HAD to get rid of that code and
now all my invoices print with a TOTAL on the bottom of each page!!)
I know the answer is probably stupid (like a property I don't know about or
something I haven't done right) but I really need a solution to this
problem!
Thanks alot!
This discussion has been closed.
Comments
choose position. Then if you are using Inches as your units, take the
height of your page, subtract the bottom margin, subtract the height of the
summary band, and that is your print position. There may be a better way to
do this, but this works pretty well.
Jim Cullison
One thing though: the detail bands print all the way to the bottom of the
page which, in that particular case, isn't good for me. The problem is that
I make the report print on pre-printed forms and detail bands HAS to stop at
a particular height (2 inches from bottom).
Is there some property I can set tthat will do that ?
Thanks again!
"Jim Cullison" a ?crit dans le message de
crew have either. Maybe you've already got a solution for this, but have
you looked at using the page style band? I am assuming you have something
in the detail band for emulating the form and the page style band is nice
because it isn't affected by the rest of the bands on the page. It's on the
Report menu. If that doesn't help, what have you got in the detail band
that you need to keep from stretching that far, and does it only stretch to
the bottom of the page on the same page as the summary band? You might get
by with some code in the detail band that checks if it is the last page.
That or set the summary band to print on a new page by itself. Something
like that.
Jim
I used the Page Style Band solution and I know I'll be using this band for
lots of other things!
No code, no mess, all I got now is a nice clean report!
THANKS A LOT!!
"Jim Cullison" a ?crit dans le message de