Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Summary VS Footer

edited September 2003 in General
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!

Comments

  • edited September 2003
    Have you tried the PrintPosition of the band? Right click on the band and
    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

  • edited September 2003
    Worked almost perfectly!

    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
  • edited September 2003
    Sorry I haven't got back to you sooner. I'm surprised that none of the D-M
    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


  • edited September 2003
    This was just perfect!

    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
This discussion has been closed.