This is what I want to do:
Each report page will list some details about a sample (like time
sampled, where, who sampled) and below it a chart showing the
distribution of the sample (i.e. numbers in categories of less than 2
oz, 2-2.5oz, 2.5oz-3oz, etc.)
I thought that I could add a chart just like in Excel but either I
cannot or am doing something very wrong. In Report Design I click on
Design at the top and then Insert Chart
The first problem I have is that I can only add 6 fields from each
record (and I have more categories for the chart than that).
The second problem is that the chart only gives a sum of the field for
all records and places that chart on all report pages (one page per
record).
And finally - it shows the sample data and not my data in the design,
report, and print preview!
Any help would be appreciated,
Scott.