Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I have a 'table 1' with a one to many with 'table 2' which has a a one to many with 'table 3'. I have a query that includes all the records, so say if client in table is smith and he has two accounts in table 2 and three transactions in table 3 on each of those accounts, then when I run the query there are 6 lines returned, which is what I require. I am now building a report which I need to structure as the tables show, so a grouping with client (1 entry), a grouping with account s(listing two accounts) and a seperate 3rd groping showing 6 transactions. I am struggling to get this to work in my report. Any guidance is welcomed.


    Thanks, Darren

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    So you do *not* want to group the accounts by client, and do *not* want to group the transactions by account.
    In that case, I'd create three separate reports, one for each of the tables, and place them below each other as subreports in the detail section of a fourth, unbound report.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    [quote name='iksotof' post='779297' date='11-Jun-2009 23:12']Hi, I have a 'table 1' with a one to many with 'table 2' which has a a one to many with 'table 3'. I have a query that includes all the records, so say if client in table is smith and he has two accounts in table 2 and three transactions in table 3 on each of those accounts, then when I run the query there are 6 lines returned, which is what I require. I am now building a report which I need to structure as the tables show, so a grouping with client (1 entry), a grouping with account s(listing two accounts) and a seperate 3rd groping showing 6 transactions. I am struggling to get this to work in my report. Any guidance is welcomed.[/quote]

    I interpret your question differently to Hans.
    I think you need two levels of grouping... not three. Group by Client, then by Account, then put the transaction specific fields in the Details section.
    For each of the Groupings create a Header, and put the fields specific to that level in the Header.
    Regards
    John



  4. #4
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='johnhutchison' post='779305' date='11-Jun-2009 12:52']I interpret your question differently to Hans.
    I think you need two levels of grouping... not three. Group by Client, then by Account, then put the transaction specific fields in the Details section.
    For each of the Groupings create a Header, and put the fields specific to that level in the Header.[/quote]
    Thank you gents, I can see the ambiguity in my post. I did mean as John interpreted.


    Thanks to you both and apologies for my delay.


    Darren

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •