Multiple Charts in Access Reports

[Chris]

I need to generate about 100 bar charts by a division. Can anyone tell me if
this is possible to do in Access? I can generate one but it doesn't seem to
be breaking and generating the others.

 

[Duane Hookom]

You might be able to create a report with each unique division. Then create a
chart in the detail section of the report and set the link master/child
properties to the Division field.

 

[Chris]

Thanks, I was able to create a graph using a subreport and it worked well.
Now my issue is that the graph has disappeared and is not displaying at all.
Any idea what could be causing this?

 

[Duane Hookom]

I can't see your report design. I'm not sure why you used a subreport and
have no idea if you did what I suggested.

 

[Chris]

I backtracked and did as you suggested. Once I set the master/child field
to the unique division the graph does not display. Both graph and report are
tied to the same table.

 

[Duane Hookom]

Can you share the Record Source and Row Source properties as well as the link
master/child?

 

[Chris]

Not sure I understand how to send that to you? Do I post it up here?

 

[Duane Hookom]

Both record sources and row sources have a SQL view. You can copy and paste
this in a reply.

 

[Chris]

SELECT qryChartWizard.Rollup, qryChartwizard.JG, qrychartwizard.fem,
qrychartwizard.totalplacements, qrychartwizard.terminations,
qrychartwizard.quarter FROM qrychartwizard;

SELECT [Quarter],Sum([Fem]) AS [SumOfFem],Sum([TotalPlacements]) AS
[SumOfTotalPlacements],Sum([Terminations]) AS [SumOfTerminations] FROM
[qryChartWizard] GROUP BY [Quarter];

The key fields are rollup and jg. The chart is creating a crosstab query and
those fields are not on the graph so they are not in the SQL. When I try to
add the master/child link the graph does not display and it saids cannot link
unbound forms.

Thanks

 

[Duane Hookom]

If the second SQL is the Row Source of the chart, I think you need to add the
Rollup and jg columns and group by them. You can then type these field names
into the link master/child properties.

There is a sample of a chart report with two linking fields at
http://www.access.hookom.net/Samples.htm.
--
Duane Hookom
Microsoft Access MVP

SELECT qryChartWizard.Rollup, qryChartwizard.JG, qrychartwizard.fem,
qrychartwizard.totalplacements, qrychartwizard.terminations,
qrychartwizard.quarter FROM qrychartwizard;

SELECT [Quarter],Sum([Fem]) AS [SumOfFem],Sum([TotalPlacements]) AS
[SumOfTotalPlacements],Sum([Terminations]) AS [SumOfTerminations] FROM
[qryChartWizard] GROUP BY [Quarter];

The key fields are rollup and jg. The chart is creating a crosstab query and
those fields are not on the graph so they are not in the SQL. When I try to
add the master/child link the graph does not display and it saids cannot link
unbound forms.

Thanks

Both record sources and row sources have a SQL view. You can copy and paste
this in a reply.

 

[Chris]

I added those and the chart messed up. I will try again but think it is time
to outsource it. Thank you for all your suggestions.

If the second SQL is the Row Source of the chart, I think you need to add the
Rollup and jg columns and group by them. You can then type these field names
into the link master/child properties.

There is a sample of a chart report with two linking fields at
http://www.access.hookom.net/Samples.htm.
--
Duane Hookom
Microsoft Access MVP

SELECT qryChartWizard.Rollup, qryChartwizard.JG, qrychartwizard.fem,
qrychartwizard.totalplacements, qrychartwizard.terminations,
qrychartwizard.quarter FROM qrychartwizard;

SELECT [Quarter],Sum([Fem]) AS [SumOfFem],Sum([TotalPlacements]) AS
[SumOfTotalPlacements],Sum([Terminations]) AS [SumOfTerminations] FROM
[qryChartWizard] GROUP BY [Quarter];

The key fields are rollup and jg. The chart is creating a crosstab query and
those fields are not on the graph so they are not in the SQL. When I try to
add the master/child link the graph does not display and it saids cannot link
unbound forms.

Thanks

Both record sources and row sources have a SQL view. You can copy and paste
this in a reply.

--
Duane Hookom
Microsoft Access MVP


:

Not sure I understand how to send that to you? Do I post it up here?

:

Can you share the Record Source and Row Source properties as well as the link
master/child?

--
Duane Hookom
Microsoft Access MVP


:

I backtracked and did as you suggested. Once I set the master/child field
to the unique division the graph does not display. Both graph and report are
tied to the same table.

:

I can't see your report design. I'm not sure why you used a subreport and
have no idea if you did what I suggested.
--
Duane Hookom
Microsoft Access MVP


:

Thanks, I was able to create a graph using a subreport and it worked well.
Now my issue is that the graph has disappeared and is not displaying at all.
Any idea what could be causing this?

:

You might be able to create a report with each unique division. Then create a
chart in the detail section of the report and set the link master/child
properties to the Division field.
--
Duane Hookom
Microsoft Access MVP


:

I need to generate about 100 bar charts by a division. Can anyone tell me if
this is possible to do in Access? I can generate one but it doesn't seem to
be breaking and generating the others.