new graph for each item in access

[Grahamvdh]

Hi


I have created a simple pivot chart that produces a graph that highlights
Date, Drill number, Metres drilled and target

The graph workes perfectly, however I need a report that will show a single graph for each drill not just one graph with filters,

Can anyone help please?

[June7]

The graph is in the Detail section of report? The report has a RecordSource that has a drill ID field? The graph has Master/Child links properties which I have never been able to get to work so I include a WHERE clause in the graph's RowSource property that refers to the key value (such as DrillID) as a parameter.

I analyse graph issues best when I can work with them if you want to provide project. Follow instructions at bottom of my post.

[Grahamvdh]

The graph is in the Detail section of report? The report has a RecordSource that has a drill ID field? The graph has Master/Child links properties which I have never been able to get to work so I include a WHERE clause in the graph's RecordSource property that refers to the key value (such as DrillID) as a parameter.

I analyse graph issues best when I can work with them if you want to provide project. Follow instructions at bottom of my post.

Gee I dont have a clue what this means.

[June7]

Do you know what providing the project for analysis means?

[Grahamvdh]

Hi June7

let me do so, sorry for being so short, kinda expected a miracle without actually doing anything.
Wont happen again

OK there is a query R daily Metres per Machine

I need to do a report om each machine number by shaft showing metres vs targets
The graph is very easy to do and works perfectly but I need to print a report on each machine.

I will also need to eventually add other measurements to this report.

Thanks you so much for any help

[June7]

Only one table actually in this db, others are links. Are the linked tables data needed? Can't do testing without data. Make copy and import the linked tables if needed. I don't see graph on forms or reports. Where is the pivot chart you reference? What objects are involved in this issue?

[Grahamvdh]

OK I have cleaned it up a lot.
The Performance form has the chart if you click on the machines filter you will see that there are hundreds
I need a graph for each and have pushed every button i could find with no success.

Thank you so much for looking at this.

[June7]

I have never used PivotChart form in any of my dbs. Only encountered them in forum posts.

I think if you want a graph to automatically generate for each machine and not have to use the dropdowns to select and view specific machine data then will have to build a graph object on the form or report and link it to the recordsource.

Try this:

1. Make a copy of the Performance form to test with. Set properties:
Allow Form View Yes
Allow Datasheet View No
Allow PivotTable View No
Allow PivotChart View No
Allow Layout View No

2. From the Design tab, drag a graph to the Detail section of form. With the wizard select:
Performance table
Date and Drilled From fields
Column chart
accept the defaults for chart layout
delete the ID link references then select Machine Number in each (first time I've ever gotten this to work)
Display legend choose yes or no
Finish

3. Edit RowSource property of the graph to be:
SELECT [Date], [Drilled To]-[Drilled From] As Metres FROM [Performance];

4. Save then view and save again

5. Use the navigation bar to move between records. When the machine number changes, the graph should change also. I might not have the metres calc as you want. I get a lot of negative results.

6. Form in design view, edit other chart properties such as titles. Double click the graph then right click OR right click the selected graph to see various editing options. Leave the edit mode by clicking anywhere on the form.