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

Problems using subreports

edited January 2005 in General
Hi,

Sorry for the cross posting, but still no answer and the problem persists:

-------------

I have the following problem, and can't find a solution, so have to ask....

Report developed totally in .RTM, to provide a receipt with original and
duplicate on the same sheet (A4).

DataSource: "SELECT * FROM PAYMENTS GROUP BY ID_EMPLOYEE"

Report (only detail band; dynamic; no datasource)
subReport (DataSource; Fixed; Traverse records)
Group On ID_EMPLOYEE

subReport (DataSource; Fixed; Traverse records)
Group On ID_EMPLOYEE

Results: Prints the upper half ok, but only prints the header on the lower
half, this on the first page, the following pages it prints on the upper the
2nd page on the lower the 1st occorrence and so on until the last page which
only prints the lower part.

Can't find way to make it right.

D5Ent; RB7.03

TYA
Manuel Troia

Comments

  • edited January 2005
    Hi Manual,

    1. Be sure there is enough space on your page to fit both fixed style
    subreports. Remember that a fixed style subreport will display the exact
    size the component apears in the designer.

    2. Be sure the Subreport.KeepTogether property is set to False, as well as
    any groups inside of the subreports.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2005
    Thks, but that's not the problem i need to break page for every group
    ocurrence and the keepTogether is disabled, and since the subreport is fixed
    type it's keepTogether is disabled too. The problem seem to be the first
    time the datasource break the page for the first subreport it can?t use the
    first page again for the 2nd subreport.

    Better there is a sample you have created to print 2 fixed subreports on a
    page, i've used it but added a left join to order (the sample used only a
    select to customers) and created a group with a new page on group break in
    both subreport and it didn't work either.

    So i would appreciate your help in trying to solve this.

    Thk again for your attention
    Manuel Troia



  • edited January 2005

  • edited January 2005
    Hi Manual,

    Sorry about the delay, somehow my newsreader lost your reply.

    If I understand correctly you would like each subreport to break to the next
    page every time the groups inside of them break, yet still print the first
    and second subreports on the same page? If this is the case, you are not
    going to get the effect you are after with the report layout you currently
    have. If you set a group to break a page, that is exactly what it will do
    inside your report, regardless if it's in a subreport or not or if there is
    another subreport to print on that page. The only way I can see to possibly
    achieve what you are after is to set up a master/detail relationship which
    will change groups for you in the main report, printing each individual
    fixed subreport for each page.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

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