Navigation:  How to > The Report Wizard > The Report Wizard Step 4: Enter Row Selection Logic >

Example of How to Create Row Selection Logic

Navigation:  How to > The Report Wizard > The Report Wizard Step 4: Enter Row Selection Logic >

Example of How to Create Row Selection Logic

Previous pageReturn to chapter overviewNext page  Print this Topic

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.
       

_bm36

 

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:

 

_bm37

 
The completed equation says, "Select this field if not all Hold Action Code information equals 0."

 

©2024 FPS GOLD. All rights reserved.