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