Newbies FC Posted April 23, 2016 Newbies Share Posted April 23, 2016 I have a table that has name, status, and Year of Start of Service. I need to run a report that shows only the ones with a status of active. I know how to generate the report with name, status and Year but cannot figure out where I insert a script or run it to get only the specific information. I am new to this and any help will be appreciated. I imagine it is a fairly basic task but am a bit lost. Link to comment Share on other sites More sharing options...
LaRetta Posted April 23, 2016 Share Posted April 23, 2016 Hi FC, You will need to perform a find before switching to your report layout. Your script, then, might look similar to this: Enter Find Mode [ ] ... do not pause Set Field [ yourTable::Status ; "Active" ] Set Error Capture [ on ] Perform Find [ ] If [ not Get ( FoundCount ) ] Show Custom Dialog [ "OK" ; "No records found." ] Exit Script End If # now you have records to generate your report Go To Layout [ 'layout based upon your report' ] Link to comment Share on other sites More sharing options...
Newbies FC Posted April 23, 2016 Author Newbies Share Posted April 23, 2016 Thank you Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2918 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now