Producing Reports by Month (using subsummaries?)
Posted on 2004-04-08
I have created a survey to measure patient satisfaction at a hospital in Pakistan, using Filemaker Pro 6.
I would like to produce a layout that allows me to view results by month. As I understand, this can be done by using subsummaries. However, when I do this, Filemaker gives VERY erratic results. Instead of grouping surveys by month, it seems to produce each and every survey that is in the set.
So, if there were 1,000 surveys over a 5 month period, I would expect to see 5 reports--one for each month. Instead I get 1,000 reports!
Also, is there any way I can allow a user to select a period of months which they wish to analyse?
Any thoughts or suggestions would be most appreciated!