The end of data is handled as a page break. The summary data for the page break is printed on the last page. To define summary data in a text element or a box element in a page layout, you need to specify which field is summarized, and which summary data is printed on the Text data prompt by typing an ampersand (&), the field name, a left parenthesis ’(’, the strings for the summary data, a right parenthesis ’)’, and a period ’.’ without inserting any spaces as follows: Text data....&SALES (*TOTAL). The strings for each summary data are: You can press the F4 key on the Text prompt of the Define Text Detail display or the Define Box Detail display to display the Select Field in Record Format display as with the Design Record Layout display. When you select a database file field on the Select field in Record Format display and press the Enter key, the Define Text Detail display (or the Define Box Detail display) appears with the selected field in the Text data prompt as follows: Text data...........&SALES (*FIRST). *FIRST is the default summary function. You can show the Define Summary Data display by pressing the F10 key, and change the summary function. You can also specify an edit code for the summary data on the display. Field . .........: PRICE Type choices, press Enter. Summary function . . . ...... *FIRST *FIRST, *LAST, *TOTAL, *AVG *MAX, *MIN, *CNT Numeric editing: Edit code . .......... 1-4,A-D, J-Q, X-Z User-defined 5-9 Edit code modifier . ...... 1=Asterisk fill 2=Floating currency symbol Define Summary Data Table33.Summarydatastrings Summary Data Strings First value *FIRST Last value *LAST Total *TOTAL Average *AVG Maximum value *MAX Minimum value *MIN Record count *CNT F3=Exit F5=Refresh F12=Cancel Chapter 10. Work with PFD Definitions 181