Results 1 to 4 of 4
  1. #1
    Join Date
    May 2005
    Posts
    119

    Unanswered: Dynamic Chart in a report

    Hi All! I'm wondering if anyone knows how to create a chart within a report, where the chart can be made visible upon a condition of data?

    For example, The report is grouped by test. Within the Test header, I would like to show the test chart (a custom chart) based upon the value of the test header group. There are two, so I need to make one chart visible, while making the other invisible.

    Ex.

    Test A
    -----------------------
    Test A Chart/Test B chart invisible
    -----------------------
    Test A Data

    Test B
    -----------------------
    Test B Chart/Test A Chart invisible
    -----------------------
    Test B Data


    Any suggestions?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    If you have passed a parameter to the report so that it 'knows' what to display
    then as part of the reports on format event select which graph to display
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2005
    Posts
    119
    I have figured it out. If you use the test group properties and create an event for "on format" it works beautifully.

    Private Sub groupheader0_Format(...)
    If me.test_grouped = "Test A" then
    me.testA_Chart.visible = true
    me.testB_chart.visible = false
    else
    me.testA_Chart.visible = false
    me.testB_chart.visible = true
    end if
    end sub

    ~Krista

  4. #4
    Join Date
    May 2005
    Posts
    119

    Thumbs up

    Quote Originally Posted by healdem View Post
    If you have passed a parameter to the report so that it 'knows' what to display
    then as part of the reports on format event select which graph to display
    Thanks for pointing me in the right direction!

Posting Permissions

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