running balance report

[RET]

I am trying to create a report from a running balance field. The things is that I only want to list the records with names and balances that owe money. In other words I only want to list records with balances above $0. How would begin to create this calculate this?

RET

[RussBaker]

Include a find step as part of the script that produces your report. Find records with a balance > 0.

[RET]

I need a little more help with this. How would this script read?

RET

[RussBaker]

Probably best to create a script that just finds balances greater than zero, and then use this as a sub-script.

To create the script... Perform and find for >0 in the balance field, create a script called "Find Balances Greater Than Zero", delete all the steps except the Find[Restore] step. Done. The finding >0 is now remembered in that script.

When you want to show you records, this new script should be called as part of your major script. Without knowing exactly how you have set things up, here is an example.

# This script finds the balances greater than zero and previews the report

Perform Script [Find Balances Greater Than Zero]

Sort [by whatever criteria you use to produce the report or sub-summaries]

Go To Layout [Report Layout]

Enter Preview Mode [Pause]

Enter Browse Mode

Go To Layout [Original Layout]

Go To Layout