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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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