Jump to content

Summary of FoundCounts from multiple Perform Find[]


This topic is 2837 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Hello all,
 
 
I have several scripts that perform a series of finds based on certain similar criteria. I'm mainly concerned about the FoundCount in each Find case.
To create my Excel summary reports, I've been entering each FoundCount in manually. This is relatively quick, but it'd be better if I could get FM to print out a summary report showing the search criteria and the FoundCount for each Find performed by the script.
Any ideas on how I'd go about this? When I tried creating a report, it didn't list every Find's results/criteria. Only the last one.

 

Thanks in advance for your help!
Link to comment
Share on other sites

At the end of each find, capture the found count in a variable and then either use merge variables on the layout or dump the results into a scratch table for your report.

 

How do you currently capture the found criteria?

Link to comment
Share on other sites

  • Newbies

I'm not capturing the found count at all, right now. The script repeats Perform Find[Restore] with set criteria and Pause/Resume Script until I'm finished viewing/manually entering the count in Excel. Should I try something like this instead?

Perform Find[Restore]

Set Variable[$Variable_Name; Value:Get(FoundCount)]

Link to comment
Share on other sites

Hi Bsharp, welcome to FMForums!  You've drawn two of the best in the business for assistance (Wim and Comment).

 

It makes sense that you can perform the multiple finds first and then use report parts (sub-summary) to group the data into the various summaries (depending upon the same criteria which you used to find the 'groups').

 

I wonder if that isn't worth trying first.  No, I don't wonder about it ... it WOULD be beneficial to see if that could work for you first.  :-)

Link to comment
Share on other sites

This topic is 2837 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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