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

two subreports with same mastertable

edited March 2002 in General
Hi,

I want to print two details with the same master on the same page ( person,
then pets of person, and then hobbies of person). I tried the folowing and
it's almost perfect except....

it repeats all pets and hobbies more than once. So it produces to much
information.


Person_information
<======detailband>
[subreport1:pets = childreport]

[subreport2:hobbies=childreport]
<======end detailband>



So what am i doing wrong ?

Regards,

Leon

Comments

  • edited March 2002
    Not enough information.

    1) Can you get this to work in TDBGrids where you move the person record and
    the detail records allign correctly?
    2) You should have 3 pipliens, and be sure each *sub-report* is assigned to
    the corresponding pipeline.
    3) Be sure the detail pipelines masterpipeline proeprty is set to the person
    pipeline.

    HTH
    Ed Dressel
    Team DM
  • edited March 2002
    Ed,

    I solved the problem.
    I put the subreports in the DETAILS region of the main report and this way
    the detailsloop is passed twice:
    1 in the detailsband of the mainreport
    2 in the detailsband of the subreport

    Leon
  • edited March 2002
    I want to do exactly this also (and honestly, have spent days on it!).

    I cannot quite follow what you are saying to fix the problem though. Could
    you please give just a few more details??

    Many thanks


  • edited March 2002
    What exactly does your report need to look like? And also, what datasets
    are available to provide the information?

    Cheers,

    Tom Ollar
    Digital Metaphors Corporation
This discussion has been closed.