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

Printing invoice divided in 2 half

edited January 2003 in General
Hello all.
Someone could help me, please, with this report, which is driving me nuts,
since almost two weeks:
The invoice divide the page in two stacked regions (Up and down).
Each region contain a subreport.
The first report list,the Items bought, with Qty , prices and subtotals
The second report list Items, with packaging and stores where item is
localized.
The two report should print on the same page.
More pages should be printed if necessary, and Titles and summaries should
print also on remaining pages.
Thanks for your help. I have studied all demos report, and no one seems to
apply to this case.
regards
Ben

Comments

  • edited January 2003
    Use two fixed style subreports. Each one is half the page. Resize the
    subreport component in the main report to be half the page in height. See
    the PrintBehavior property of the subreport in the help file for more
    information. The fixed style subreport should reprint the data on the
    following pages if it needs to. See the TraversalAllData property topic in
    the help as well.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited January 2003
    I did exactly that.
    The first page is printing correctly. But the remaining pages are not. It
    seems that the first subreport continue printing to end. Then the second
    report.

  • edited January 2003
    Using the DBDemos database and DADE, I created a master dataset on Customer
    and two details. One is the Orders table and the other a sum calculated
    field for each order. This results in two datasets of different lengths,
    since the second detail dataset is always one record(the sum calc field).
    Here is a report which prints the order information bands in the top
    subreport and the bottom page is the sum calc field report. This should show
    multiple detail bands along with a group header, footer, title and summary,
    all using more pages if necessary. The bottom report doesn't need extra
    pages, so it just prints on the first page of each customer master record
    group. I did this just to make the second subreport print differently than
    the first to test pagination in this case. There is a group in the main
    report so that the report can break to a new page so that the subreports
    don't try to reprint after each other when traverse all data is set to true.

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

    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.