Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm struggling with a report that's giving me extraneous pages; if there is more than one 'condition' in a sub-table, I get a page for each record in the sub-table.

    I know I've not explained it properly, but if you look at the attached, hopefully you'll see what I mean.

    Anyway, can anyone explain what it is I'm not doing?

    TIA
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The sub-subreport rptSubEnviro is linked to the subreport srptConditionEnviro on ID and Condition. The subreport srptConditionEnviro is based on the table tblCondition, but the combination of ID and Condition is not unique within this table. For example, ID="EA1.02" and Condition="Normal" occurs 4 times. So you'll get a repetition of the same subsubreports 4 times.

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank Hans. Let's see if I have the right of this; I need to add another field (eg HazardImpact) to tblcondition & use this to link parent/child fields?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You don't have to add the field to the table - it already has a field HazardImpact. But you need to add it to the Link Master Fields and Link Child Fields properties of the subsubreport on the subreport:
    [attachment=83990:x.png]
    Attached Images Attached Images
    • File Type: png x.png (5.3 KB, 0 views)

  5. #5
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ah got it!

    That's what comes for picking up something that wasn't finished months ago (and it was me that started it )

    Thanks once more

Posting Permissions

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