Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Get rid of duplication of charts (access97 sr2 xppro)

    I have a report which produces a chart bsed on an underlying query.
    The underlying query reports on the client and their previous years worth of turnover.
    So for each client I have a chart within the detail section of the report.
    The query for the chart (should) return only that data relating to the detail section client ref.
    The problem is that the charts appear to be duplicating randomly each time the report is opened.
    i.e. for clients 1 to 10, the first time the report is run, clients 2 and 3 may have same chart values and clients 5 and 6 may have same chart values.
    The second time the report is run it may be clients 4 and 5 that have the same chart values.

    Hope I've been clear enough in explaining the problem.

    Any suggestions?

    TIA
    Alan
    Cheshire

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Get rid of duplication of charts (access97 sr2 xppro)


  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Get rid of duplication of charts (access97 sr2 xppro)

    Thanks Hans.
    Read the microsoft kb but still didn't resolve it.
    MS are advising update to SR1, but we're already at SR2 so I guess I don't want to regress any further.

    Tok a break there and redesigned the report to have the chart NOT part of the main report but a sub report which then allowed me to link the master and child fields.
    That seems to have sorted it.

    Conclusion:
    When producing charts which need segregating into individual clients, put the chart on a report and then make that report a sub-report of your main report (nearly lost myself then). Link the master child fields to your client ref and voila.

    Many thanks once again Hans.
    And a merry christmas to all.

    Alan
    Cheshire
    UK

Posting Permissions

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