[AccessD] A2000: And now, a graphing question (swe)

Steve Erbach erbachs at gmail.com
Thu Feb 10 19:09:02 CST 2005


Dear Group,

Now I've got an issue with graphing in a report in the project I'm
converting to Access from Paradox.

The Paradox application allowed a graph to print in a group header or
footer that sumamrized data appropriate to that group. Then an overall
graph would print in the report footer. Here's what the raw data looks
like:

SourceID  |  Type  |  Amount
5  |  Used  |  15000
5  |  Waste  |  3000
6  |  Used  |  20000
6  |  Waste  |  5500
7  |  Used  |  18000
7  |  Waste  |  2100
etc.

The graphs are pie charts showing the pair of values for each SourceID
as percentages in the pie. Just two slices per SourceID. Then, of
course, the overall total pie chart at the end of the report.

I tried inserting a pie chart into the group footer (I even tried in
the group header) on my Access report. Using the wizard I picked the
two data fields, Type and Amount, picked the chart type, and then got
to the part where the wizard suggested the Link fields. The wizard
automagically picked SourceID for both Master and Child links, so I
went on, gave the chart a title and finished the wizard.

But when I go to preview the report, I see the box for the graph as
well as the title, but no pie chart. Back in Design mode I clicked on
the Data tab in the Graph properties box and clicked on the Link Child
Fields button ( ... ). I then got an error message:

Subreport Field Linker
Can't build a link between unbound forms.

If I erase the SourceID from both the Link Child Fields and Link
Master Fields, then I get a graph...but it's the same as the summary
graph in the report footer. I can't seem to get the graph to show only
data appropriate to the group in the report.

Any ideas?

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security



More information about the AccessD mailing list