Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    268

    Unanswered: Dynamic Charts in a Report

    All of you reporting wizards out there, I need some help on something.

    I have a set of data (obviously) and I want to group this data. The detail displays the information, while on the grouping footer I want to include a chart for the above listed data.

    Right now I am pointing the chart and the report to the same set of data, but am thinking I need to do a filter or something like that on some event in the report to whow the respetive data.

    Anyone have any suggestions, ideas on this one. I can include an example of what I am working on if this may help anyone.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    You need to link the Report as one

    Look under the
    Link child Fields
    Link Master Fields

    Once you have this right MSaccess will do the work for you...
    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
    Dec 2003
    Posts
    268

    Tried It

    This won't work, or I should say, I haven't gotten it to work. The chart looks at it's own dataset autonomously from the reports dataset.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    but what you do is .................................................. ...

    put the chart into it own report with the same record source and get the chart to point to 1 feild on that report in the critere of the chart.

    save it

    know in the main report in that foooter have the same feild then (master feild)

    the 1 feild in the chart report some the (child feild) as the chart is link to that feild it will only show the value of that value

    I use it for my LTI (lost time injury)

    I have a report grouping by departments show the summary of the Month but on the footer of the depart it shows there year to date graph there LTI injurys
    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.

  5. #5
    Join Date
    Dec 2003
    Posts
    268

    Per your suggestions

    I did as you suggested and no success. I have included an example DB with the issue.

    The subreport is not reflecting the correct information for what is listed above.

    The data is purely for testing reasons but should be sufficient to provide enough information.

    This seems to be possible but I can't figure out where or how to dynamically assign a data source object to the chart with out it A)effecting all of the charts B)assign data values when the system will let me.

    Thanks in adavance all.
    Attached Files Attached Files

  6. #6
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    done

    Have done it 2 ways for you

    report1 by its self

    and also

    report 3 using the child idea

    (sorry there a little trick here have to link it ot the [Reports]![Report3]![Child26].[Report]![TMID]
    not to
    [Reports]![Report2]![TMID]







    happy new year
    Attached Files Attached Files
    Last edited by myle; 12-28-05 at 21:58.
    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.

  7. #7
    Join Date
    Dec 2003
    Posts
    268

    Thumbs up Thanks a ton

    I tweaked what you did a little to reflect the joining on year too and cleaned up the data so it made some sense.

    Thanks for your help, I can't believe it was something like that, I had been working on this the majority of the latter half of the day. Li
    Attached Files Attached Files

Posting Permissions

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