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

Master Detail

edited November 2003 in Subreports
RB 6.3

I need help with making a report from an Address Database with three linked
tables.:

tblName ->tblAddress->tblPhone

Consider the fields:
tblName.Name, tblAddress.Address, tblPhone.PhoneNo

I would like the all of these related fields to print beginning on the same
line - like:

Jones 123 Main St. (555) 123-1234
P,O Box 1234 (555) 234-5678
(555) 345-7890

Smith 345 A St. (666) 666-5432

.
.
.

I have been able to arrange sub reports, or any other method, to accomplish
that format. All help will be appreciated.

Wil

Comments

  • edited November 2003

    Try using side by side subreports to prin the tablAddress and tablPhone
    data. We have an example of this in the RBuilder\Demos\Reports\Demo.dpr -
    the example is slightly different because the master has two details that
    are linked to it. But I think the same approach will work.

    To implement side by side subpreports, set subreport.ParentWidth to false so
    that you can resize the width.


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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited November 2003
    Could you direct me to the report in question? I find that there are many
    reports in that program.

    Thanks.

    Wil

  • edited November 2003
    Sounds like you're using TTables, but if you can switch to TQuery, do a join
    on the three tables to get them into one dataset, which will make it very
    easy to build a report from.

    Also, why are the tables separate in the first place? It sounds like you
    should have a single customer table with all that info combined. I am just
    spouting off... so ignore this if you like.

    Jim

  • edited November 2003

    Demo number 73 (dm0073.pas) in RBuilder\Demos\Reports\Demo.dpr

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

    Best regards,

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