Summary of FoundCounts from multiple Perform Find[]

[bsharp]

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!

[Wim Decorte]

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?

[bsharp]

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)]

[Wim Decorte]

Yes.

 

But I was wondering why you'd want to capture the find criteria since those are static; you've made them to be what they are... so?

[comment]

I have several scripts that perform a series of finds based on certain similar criteria.

 

 Is this really necessary? What exactly are these "certain similar criteria"? Couldn't you simply summarize the records?

[LaRetta]

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.  :-)