Home General

Help with report design please

edited June 2001 in General
Hi, let me describe how I want my report to look and act.
My two tables are in a Master Detail relationship.

Static Report Heading: At Top Of Every Page

Master Heading(contains data from master table): As long as their are
detail records

Static Detail Heading: As long as their are detail records

Record
Record
Record
...


Static Heading: At Top Of Every Page

Master Heading: As long as their are detail records

Detail Heading: As long as their are detail records

Record
Record
...
etc.

No band should split across pages.

How Do I do this?

TIA, Darin

Comments

  • edited June 2001
    <<CORECTED>>
    Hi, let me describe how I want my report to look and act.
    My two tables are in a Master Detail relationship.

    Static Report Heading: At Top Of Every Page

    Master Heading(contains data from master table): As long as their are
    detail records

    Static Detail Heading: As long as their are detail records

    Record
    Record
    Record
    ...


    Static Heading: At Top Of Every Page

    Master Heading: As long as their are detail records

    Detail Heading: As long as their are detail records

    Record
    Record
    ...
    etc.

    No band should split across pages.
    Can I test the vertical size of the detail band and then decide weather
    I want to let it split or print fully on the next page?

    How Do I do this?

    TIA, Darin
  • edited July 2001

    Sorry, for not responding sooner.

    1. Create a main report with a header/detail/footer.
    2. Connect the Report.DataPipeline to the master.
    3. Add a group to print for each master record and set reprint on
    subsequent pages to true. You can optionally set KeepTogether to true.

    4. Add a subreport to the detail band. Optionally set
    subreport.KeepTogether to true.
    5. Connect the subreport to the detail data.
    6. Access the workspace for the subreport and remove the title and
    summary. Note: Rather than a group on the main report, you can probably
    add a group to the subreport instead - your preference.
    7.






    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.