Jump to content
Sign in to follow this  

Filter records to show on report

Recommended Posts

Dear All,

I know this might a very easy question, but it's really giving me hard time, I'm new to FM, I'm coming from Access / VB background so maybe I'm still trying to do things in FM the Access way.

My question is that, I have a table which has members information, there is one field which called "Status", what I want to do is that to have a button on the main screen and when I click on it shows a report which have only members with the "Status" = "Active" only. The report is grouped by Team name, so every team have some members related to it and this work fine.

I designed the report and it's working fine, except that it shows all the records not the one with "Active" status only. So I would appreciate if someone can provide me the steps of the scripts which i can attach to this button to perform what I want.

Share this post

Link to post
Share on other sites

Hi Seifo,

You would need to add a Find Step to your script. I like handle that like this:

Enter Find Mode

Set Field (Status; "Active"

Perform Find

  • Like 1

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.

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.