libbystow

I have a runtime file using two values lists. Depending on which category value is chosen on one list then the other list displays a list of values available for that category. This works fine except I now notice in FM Advanced that the value list appears to drag, usually displaying what looks to be multiple copies of the 2nd value. Of course chosing it makes the copies disappear. I think this must be a screen refresh problem that has just crept into the new version. It certainly never happened in Developer 7. Any ideas how to fix this?

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

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

Are you using a grandsummary part?