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

How to stop text in subreport to display at the middle page

edited June 2005 in Subreports
Hi,

I am new and using RB 7.03. Could you please show me how to design a report
with the following requirement:

I have a report contain Header, Detail and Footer. In Detail Band, I want
to display 2 subreports called subreport1 and subreport2 in 2 rectangular
areas. Subreport1 is displayed on first half of a page and Subreport2 is
displayed in second half of the page. If data in Subreport1 or Subreport2
longer than the length designated area, data will continue to be printed on
the second page.

Here is how it looks like

On Page1:

HEADER
DETAIL BAND
-----------------------------------
| |
| Subreport1 |
| |
| |
-----------------------------------
| |
| Subreport2 |
| |
| |
-----------------------------------
FOOTER

On Page2:

HEADER
DETAIL BAND
-----------------------------------
| Continue of |
| Subreport1 |
| |
| |
-----------------------------------
-----------------------------------
| Continue of |
| Subreport2 |
| |
| |
-----------------------------------
FOOTER


On Page3:

HEADER
DETAIL BAND
-----------------------------------
| Continue of |
| Subreport1 |
| |
| |
-----------------------------------
-----------------------------------
| Continue of |
| Subreport2 |
| |
| |
-----------------------------------
FOOTER

Thank you so much!

Vinh

Comments

  • edited June 2005

    Welcome to ReportBuilder :)

    For each subreport

    1. Set SubReport.PrintBehavior to pbFixed and size the subreport control to
    occupy the desired area of the page.

    2. Set SubReport.TraverseAllData to True. This is a special property that
    applies to pbFixed subreports and enables them to overflow (i.e. continue
    generating) on additional pages as needed. Connect each subreport to an
    appropriate datapipeline.




    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited July 2005
    Thank you. It works.

    Vinh

  • edited July 2005
    Hi Nard,

    Thank for your big help.

    I have another problem regarding this matter:

    I have each subreport displayed on each half of a page. However, data in
    each subreport print over the next page too soon, leaving the current page
    with lot of empty space. I already set the bottom offset of each subreport
    to 0.

    Please tell me what is wrong.

    Thanks,

    Vinh
  • edited July 2005

    Try downloading a trial version of RB 9 and perform the same test.

    A pbFixed subreport should only overflow when it reaches the end of the
    boundary defined by the subreport control. I think I recall there was an
    issue with this that has since been fixed.


    --
    Nard Moseley
    Digital Metaphors Corporation
    http://www.digital-metaphors.com


    Best regards,

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