Multiple Charts in Access Reports

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
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.
 
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?
 
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.
 
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.
 
Can you share the Record Source and Row Source properties as well as the link
master/child?
 
Both record sources and row sources have a SQL view. You can copy and paste
this in a reply.
 
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
 
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


Chris said:
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 said:
Both record sources and row sources have a SQL view. You can copy and paste
this in a reply.
Click to expand...
Click to expand...
 
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.

Duane Hookom said:
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


Chris said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top