Navigation: How to > The Report Wizard > The Report Wizard Step 4: Enter Row Selection Logic >
Example of How to Create Row Selection Logic
For your understanding, the following is an example of how to create row selection logic in Step 4 of the Report Wizard.
Steps
1. | In Report Wizard Step 4, click in the large white box at the bottom of the screen. |
2. | Type "!" then a space, then a "(" symbol. |
"! (" now appears in the white box. |
3. | Select "ALL(RepeatingField =<><=>= value)" from the Function list. |
The following expression will appear after "! (": |
ALL(RepeatingField =<><=>= value) |
4. | Double-click on the words "RepeatingField" in the new formula. |
RepeatingField is now highlighted. |
5. | Click on "Hold Action Code" in the Report Column Heading list. |
"RepeatingField" will be replaced by "Hold Action Code." |
6. | Click and drag the mouse across <><=>= in the formula. |
7. | Press <Delete> on the keyboard. |
8. | Double-click on the word "value," and type "0." |
9. | Click outside the parenthesis after "0," and click . |
The calculation is now complete and looks like the following: |
The completed equation says, "Select this field if not all Hold Action Code information equals 0." |