Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Master detail in Multiple Column report

rbuserrbuser
edited February 2006 in General
Hi,

I need to design a Multiple Column report which gets data from multiple
Master-Detail datasets. Number of columns of the main report is set to 3. I
placed some DBTexts from the Master dataset and a child subreport linked to
the Detail dataset on the main report. In the child subreport I placed some
DBTexts from the Detail dataset.

This is what i would like to have:
Column 1 Column 2 Column 3
Master data 1 Master data 1 Master data 2
Detail data 1 Detail data 2 Detail data 1
Master data 2 Master data 2 Master data 3
Detail data 2 Detail data 3 Detail data 1

This is what i get:
Column 1 Column 2 Column 3
Master data 1 Master data 2 Master data 3
Detail data 1 Detail data 1 Detail data 1

Greetings,
Filip Moons

Comments

  • nicociziknicocizik
    edited February 2006
    Hi Filip,

    I'm a bit unclear about your report design. Note that each report or
    subreport can only be connected to a single dataset and therefor can only
    traverse one dataset. From your description below it looks as though you
    would like to print the detail data for the first master dataset (first)
    record, then skip to another subreport where the detail data is printed from
    the second master dataset (first) record. ReportBuilder by definition will
    finish printing a subreport before moving on to the next. One option my be
    to create a Master dataset to control the Masters you already have. Then
    you will essentially be creating a Master-Detail-Detail.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • rbuserrbuser
    edited February 2006
    Hi,

    Ok, I finally figured it out. Master-Detail only seems to work in Multiple
    Column reports when Top-To-Bottom traversing is applied instead of
    Left-To-Right traversing as i was initially doing.

    Greetings,
    Filip Moons

  • nicociziknicocizik
    edited February 2006
    Hi Filip,

    Glad you got is sorted out. The Left To Right traversal feature in RB is
    very limited and should only be used for very simply reports. Problems tend
    to arise when adding multiple datasets and groups, etc.

    --
    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.