Summary Field Sort

[jbullydawg]

Good Morning,

I have a report that consists of only summary fields. The final and most important field is a Balance Due field which is a summary total of all registrants in a particular program. I'd like the report to only display those Balance's Due that are greater than zero. Unfortunately, FM won't let me constrain the report based on a summary field. Any ideas?

SummaryBalanceDue > 0

Thanks for any help!!

[Søren Dyhr]

Come again, other fields must exist beyond the summary fields, we're not talking of the layout, but the table from where the reporting is done.

FM won't let me constrain the report based on a summary field.

Wrong! You can use an Edoshin alogrithm for this, exploiting the GetSummary( function while looping thru your found set. For each breaker value would the script deside to keep or omit the record... To keep the values for each breaker must a field be set to the value of the summary pending in the record that remains after the omiiting.

Now this description have become un-intendet cryptic, but if you rush to:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

...is there a chance you get what I mean in the above.

--sd