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

Two reports without a new page

edited July 2004 in General
Hi,

This should be simple but I can't get it working.

I need two reports with headerband detailband and footerband like two
subreports in a detailband setting all subreports to section style. This is
what I'm trying to achive but no new page. I tried almost all settings in a
summaryband and so on but in vain. Child reports is working, but here I lost
the headerband. Is there a solution?

Thanks in advance

Martin Cremer

Comments

  • edited July 2004
    Matin,
    look at regions (fixed) in wich you place a subreport
    cu
    marc

  • edited July 2004
    Hi Martin,

    Since Child Subreport do not always take an entire page, there is not page
    header or page footer available. As an alternative, you could use the Title
    and Summary bands or create a group inside the subreport and use the group
    header and group footer.

    ------------------------------------------------------------------
    Tech Tip: Subreport header/footer bands do not print for
    Child type subreports.
    ------------------------------------------------------------------

    For a subreport set to pbChild, the header/footer are not supported.
    A child type subreport prints on its parent's page space and
    therefore behaves more like a memo.

    Options:

    1. Use Title/Summary band.

    2. Use GroupHeader/GroupFooter. If you need to repeat the header
    when a page breaks then then you can create a group and
    set StartNewPage to True.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2004
    Hi Nico,

    thanks for your answer but what I am going to achieve is probably not
    possible or send me the following example.

    Two reports should combine as follows.

    All reports have header, detail and footerband.

    The first report is connected via bdepipeline1 to table1 customer.db.

    Drop a label onto the headerband. Caption is "First Report - Header".
    Drop a dbtext onto the detailband and connect this to "company". For better
    looking set autosize to true.
    Drop a systemvariable onto the footerband. Set VarType to vtPageNo.


    The second report is connected via bdepipeline2 to table2 employee.db.

    Drop a label onto the headerband. Caption is in this case "Second Report -
    Header".
    Drop a dbtext onto the detailband and connect this to "Firstname".
    Drop a dbtext onto the detailband and connect this to "Lastname".
    Drop a systemvariable onto the footerband. Set VarType to vtPageNo.

    There is no problem to get the first report working.

    The first report starts with "First Report - Header". then the details with
    Kauai Dive Shoppe to Neptune's Trident Supply and on the bottom of the page
    the "1".

    Now it's getting tricky.

    The first report should end in the middle of page two.
    The second report should start just behind the first report with

    "Second Report-Header"

    then the detail band from Roberto Nelson to Mark Gugenheim.

    This page should end with the systemvariable of either report1 or report2
    but "2".

    The third page starts with

    "Second Report-Header"

    then the rest of the names

    following by the footer with "3".

    That' all. Seems to be easy. But is'nt.


    Thank to all

    Martin Cremer













































  • edited July 2004
    Hi Martin,

    I created a quick example that shows how you might go about doing this.
    Hope it helps...

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

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.