I have a fmp6 db that keeps tracks of requests made.the requests have codes and they are all unique. I also capture the dates these requests were made. Now I would like to create a report that shows the number of requests made each year and even go back 4 or 5 yrs.The format looks like:

2006 2007

req1 34 25

req2 37 3 and so on.

for instance, I have a calculated field

Case(request_code = "CLT" and Year(Date requested)="2007",1) and then a summary field that gives the total count of the calculated field. It seems to work fine but with one problem.

Any time a request is made/selected from a valuelist, the summary field has to update and it's becoming annoying and slows the system. how can I do this without using summary fields and also if possible create a separate file/TO to handle just this report. Please help!!!

Is there some reason you are not using just a regular sub-summary report? File attached FM7. I am assuming that even though the file you are talking about is FM6 you can view the FM7 file attached... your profile shows you have FM8 Advanced.

RequestReport.zip

thanks sbg1, however I tried your method but the Summmary field value would not show in the report.I've double checked everything, cant figure out what the problem is.

never mind, I figured it out. Thanks for your help!