Home Subreports
New Blog Post: Email: Multi-Service

Master-Detail Report joins

edited July 2008 in Subreports
Hi there,

I'm doing a hobby application for my Krinklies Klub and I am 10 years into
retirement so my skills are fairly rusty and I have hit a snag and can't
think of a way around it. Can anybody put me on the right track please.

I have two simple tables: tblMembers and tblGroups. Members can belong to
groups or not. There are only about 70 records in the table.

I want to do a report, one page per member with all their details plus a
sub-report listing all the groups they belong to if they belong to any.

I have followed the example in the Customer/Order Demo but it only prints
details for members who belong to groups, like an inner join. I want it to
be like a left join where it prints all members with the addition of their
groups if they belong to any. I am doing it with queries, not tables for
selecting and ordering stuff but I can't get it to fly using joins.I have
tried using table components with an index, as in the example but that
doesn't work
either.

I think I am missing the bleeding obvious but I can't see it.

I am using D6 and RB 6.03 with a remote MySQL DB

Many Thanks,


--
(\__/)
(='.'=)
(")_(")

Comments

  • edited July 2008
    For the detail DataPipeline set SkipWhenNoRecords to False

    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited July 2008
    You are a Prince amongst men. It worked a treat.

    Thanks for that


This discussion has been closed.