I have a databse of 200 records which can be sorted in categories. I have all my totals working. The report can show the totals for a found subset of the records, say 20 records of the 200 present. I have five summary fields like the following:

Tot1 = 8

Tot2= 6

Tot3= 2

Tot4= 0

Tot5= 4

Now I want to use these totals to generate a graph. My only problem is the summary fields are reading the totals for all the records when it comes to graphing them, rather than just the subset totals as shown above.

Do I need to create five global number fields and set them to the subset totals using a script?

I'm not sure how to do this step. Any help greatly appreciated.

Cheers

Libby

Try using a calculation with GetSummary( summaryField; breakField ). This should be consistent for each record within a particular category, assuming the records are sorted accordingly.

Also, I do not see why you would require five summary fields. One should do the job correctly for each subsummary grouping.

Hi and thanks for the advice. I had already done as suggested and therein lies a problem. It seems with a GetSummary field although it summarises data by the breakfield it doesn't actually hold the breakfield summary data, in this case the breakfield total. So, if I try to use this total in another field it seems all the records in the data set are considered and thus a total for all the record data are used, not just the Getsummary data.

I need five Getsummary fields because each holds data for a graph using five categories: Strongly Agree, Agree, Don't Know etc. The idea is the Getsummary field holds a total for a subset of records by a breakfield category and the data are used as part of the chart for each chart category. But for the reason mentioned in the first paragraph it isn't working as I would have expected.

What would you suggest?

Regards

Libby