Jump to content
Sign in to follow this  
zoom007

report-show number of requests

Recommended Posts

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!!!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.