Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    65

    Unanswered: subreport data duplicates 9 times

    Hi

    i have a report with a linked subreport (links on studentid, exam, year)

    the problem i have is that im getting duplicates of my subreport within my main report. the sub is appearing 9 times and im not sure why....

    i prevciew the report with a button which filters the report to the values in three drop downs- studentid, exam, year.

    therefore if i pick a value from each the subreport should filter to those values, it is but it's dupliacting it 9 times..

    any ideas?

    greg

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Look @ the way the data is Group and grouping of the data also the Relationship could be a problem
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    May 2006
    Posts
    65
    hi,

    no its not to do with any grouping.

    essentially the report source is a distinct select which selects name, examid, studentid, and yearid.

    the subreport has studentid, examid, termid and it's these fields which are joining the two togther.

    now all my reports are coming out ok bar a few. i simply dont understand why the main report isn't filtering the subreort contents.

    for example a report that works has

    studentid- 1343 termid- summer yearid- 2004/2005

    and the sub has these values

    studentid- 1343 \termid- summer EOT \yearid- 2004/2005

    but a report that doesn't work has these values

    studentid- 1343\ termid- summer EOT\ yearid- current ye

    AND THE SUB GIVES ME
    studentid- 1343\ termid- summer EOT\ yearid- current ye
    and
    studentid- 1343\ termid- summer HT\ yearid- current ye

    why?

    greg

Posting Permissions

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