Designing the Procedure Logic › Group View Manipulation › GET ROW VISIBLE Statement

GET ROW VISIBLE Statement

The GET ROW VISIBLE statement can be used with a filtered group view to select a visible row in an explicitly indexed repeating group view. The GET ROW VISIBLE statement is a companion to the FILTER statement.

This statement can be used to count the following rows:

• Number of rows visible or invisible so that the number of rows that were unfiltered or filtered can be displayed.
• Further process rows that were (not) filtered.

For example, the filter may have selected all accounts in ZIP Code 75208.

The next action is to add up all the balances for the selected ZIP Code. GET ROW VISIBLE is used to cycle through the filtered rows and add up the balances.

A conditional statement may be used to test whether an implicitly indexed repeating group view is visible or not.