Results 1 to 5 of 5
  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 am having considerable bother in getting a report to behave how I wish and therefore to be able to total fields etc. I have posted quite a few isolated questions on reports recently and am perhaps guilty of not making myself clear. I have a main table with say main ID, from this I have a many scheme table with schemeID. Scheme has two many to many relations with risks and checks. I have created appropriate junction tables for each. I have combined all these in one query to show all records.

    On my report I DO want groupings but have an issue around how I model the two junctions since they are at the same level in terms of relations so I do not one grouping over the other. If I consign these to the details section I end up with mutliple lines, so if I have 2 risks and 3 checks I end up with six lines which is not what I want and is confusing to the reader, (first risk is shown 3 times each with one of the checks next to it, then similarly for the second risk . I need the 3 risks showing in isolation and similar the 2 checks but obviously linked to the appropriate scheme. Suggestions would be most helpful.




    Many thanks, Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    More or less as in Post 779304, I suggest that you create a main report for the schemes, with a subreport for the checks and a subreport for the risks. Both subreports would be linked to the main report by SchemeID.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This seems to be more like Hans, sorry for my lack of understanding. I have not manually linked reports previously, so if report 1 is the main and has spk as the scheme ID and then report 2 is one of the many to many with spfk as the scheme link, what do I actually put in the property link master and child? I have tried the ellipse builder but it doesn't recognise an unbound report.


    Cheers, Darren.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The main report should be bound to the Scheme table.
    One of the subreports should be bound to the Checks table, and the other to the Risks table.

    The Link Master Fields property should list the linking field(s) in the main report, in this example spk.
    The Link Child Fields property should list the corresponding field(s) in the subreport, in this example spfk.

  5. #5
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='781580' date='25-Jun-2009 00:02']The main report should be bound to the Scheme table.
    One of the subreports should be bound to the Checks table, and the other to the Risks table.

    The Link Master Fields property should list the linking field(s) in the main report, in this example spk.
    The Link Child Fields property should list the corresponding field(s) in the subreport, in this example spfk.[/quote]


    Thank you Hans for your patience.

Posting Permissions

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