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

Sub-report positioning problem

edited December 2002 in Subreports
Using D6, Rb Pro 6.02, Advantage

I'm printing a fairly standard master-detail report similar to demo 61. The
master report detail band contains the sub-report only. The detail band has
a PrintPosition set at 4 inches.

Problem 1:
I need to stop printing detail at 8 inches and go to next page if necessary.
The sub-report contains stretchable components. How do I stop printing at 8
inches and proceed to the next page?

Problem 2:
I need to print a summary of the detail at 9 inches of that page. (i.e.. the
last page of the sub-report). If I try to set the print position in the
sub-report, I get an error indicating it is trying to print beyond the
bounds of the page. And if I try to use a calc component on the master
report for the detail items, I only get the total for the first line item.
How to I calculate a total and then position it at the bottom of the page?

Any guidance would be appreciated.

TIA
John

Comments

  • edited December 2002
    Well, I guess it couldn't be much more obvious than the StopPrint property
    of the sub-report. Now I'm only trying to figure out problem 2.

    Thanks.

    necessary.
    8
  • edited December 2002
    You want to move a summary band to the bottom of the page? You should be
    able to do this with the print position, if it is a static height control.
    Otherwise, if it is static height, you can position it on the fly using draw
    commands. Here are two examples:

    http://www.digital-metaphors.com/tips/SummaryReplacesFooter.zip

    http://www.digital-metaphors.com/tips/AlignSummaryToBottom.zip


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited December 2002
    Thanks for the guidance Jim.

    However, the problem wasn't just positioning the summary band, it was
    positioning the summary band on a sub-report while limiting the detail band
    on the sub-report to a maximum page position. (i.e. detail band prints from
    4 - 8 inches, summary band starts at 9")

    Although I'm sure there is a more elegant solution, I worked around the
    issue by saving the summary information in variables rather than using the
    DBCalc component and then printing the variables on the master report.

    Thanks again for yours and all of DM's support.

    John

This discussion has been closed.