When I display a chart that is within a report, the chart is replicated 15 times. I have 15 different charts all together to display different charts based on data within my tables, but when the user selects a specific chart, it should only show one instance of the chart and not replicated 15 times.
I realized that this replication occurs when I have the record source set to my data table in the report properties. The problem is that the user can change the data in the table and I want the graph to update once the user finishes updating the table (user clicks SAVE when table data editing is complete). Without having the record source set in the Report properties, the chart does not update to reflect the changes in the table. It works perfectly when the record source is set but then the chart is replicated 15 times, which I don't want; I want it to show on once.
So my question is, how do I update the chart (user clicks SAVE) to reflect the table changes without setting the record source in the Report? I have added an attachment to show what my output looks like. I would greatly appreciate help or examples of fixing this issue.
Chart Replication.pdf