IN DEX Character data type formats of, 165 1 Demonstration tables, A-1 - Character values A-4 default justification of, 1st page only prompt, 218 Desc prompt, 206 145 Device name prompt, 201 A Columns of the work area, 15 Display a Final Footer Compare Element to window, window, 122 Add a New Element window, 75, 93, 175 Display a Sort Footer window, 50, 179 Compare to Element window, 31 Add Element window, 51, 94, 95, 176 Display a Sort Header 180 Compare to Value window, window, 31, 108, 156, 157 Add Query window, 4 76, 175 Display column, 15, 136 Address prompt, 218 Control break items, 216 input functions, 136 Allow scrolling prompt, 206 Control breaks Display Element Format AND operator, 84, 212, 213 example of, 104 window, 39, 41, 116, 139 changing to OR, 209 Copy from query prompt, 5 Display format of evaluation, 213 advantages of, 131 deleting, 139 Arrow keys, 9 definition of, 131 editing, 139 Ascending/descending order, Copying text, 210 Display format parameters, 30 Cost prompt, 207 125 Average all values function, Count all rows function, 57, Display if NULL prompt, 56, 156 156, 169, 215 166 Display sequence, 136 example of, 169 Count all values function, Display Sequence window, Average distinct values 156 Count distinct values 25, 38, 137 function, 156 function, 156 Display text if NULL prompt, Count function, 57 40, 151 B Cursor movement keys, 9, 14 Display this Element window, Cutting text, 210 24, 137, 161 Bottom margin prompt, 221 Displaying elements, 137 Breaks option, 122, 215 D Download data, 206 Breaks prompt, 204 Duplicates in a report Dash line prompt, 219 suppressing them, 150 C Data type prompt in Calculation E Calculation element, 49, 180 Information window, adding, 189 189 Edit option, 15, 135 and complex test in Prompt Information Edit Tests window, 80, 92 logic, 192 window, 89, 188 Edit the Display Format referencing other Data types, 141 window, 139 elements, 191 list of, 89 Element column, 15 Calculation Information Date/time prompt, 219 Element definition window, 189 Deleting a query, 130 viewing, 194
IN DEX 1 1st page only prompt, 218 A Add a New Element window, 50, 179 Add Element window, 51, 180 Add Query window, 4 Address prompt, 218 Allow scrolling prompt, 206 AND operator, 84, 212, 213 changing to OR, 209 of evaluation, 213 Arrow keys, 9 Ascending/descending order, 30 Average all values function, 56, 156 example of, 169 Average distinct values function, 156 B Bottom margin prompt, 221 Breaks option, 122, 215 Breaks prompt, 204 C Calculation element, 49, 180 adding, 189 and complex test logic, 192 referencing other elements, 191 Calculation Information window, 189 Character data type formats of, 165 Character values default justification of, 145 Columns of the work area, 15 Compare Element to window, 75, 93, 175 Compare to Element window, 94, 95, 176 Compare to Value window, 76, 175 Control break items, 216 Control breaks example of, 104 Copy from query prompt, 5 advantages of, 131 definition of, 131 Copying text, 210 Cost prompt, 207 Count all rows function, 57, 156, 169, 215 Count all values function, 156 Count distinct values function, 156 Count function, 57 Cursor movement keys, 9, 14 Cutting text, 210 D Dash line prompt, 219 Data type prompt in Calculation Information window, 189 in Prompt Information window, 89, 188 Data types, 141 list of, 89 Date/time prompt, 219 Deleting a query, 130 Demonstration tables, A-1 - A-4 Desc prompt, 206 Device name prompt, 201 Display a Final Footer window, 122 Display a Sort Footer window, 31 Display a Sort Header window, 31, 108, 156, 157 Display column, 15, 136 input functions, 136 Display Element Format window, 39, 41, 116, 139 Display format deleting, 139 editing, 139 Display format parameters, 125 Display if NULL prompt, 166 Display sequence, 136 Display Sequence window, 25, 38, 137 Display text if NULL prompt, 40, 151 Display this Element window, 24, 137, 161 Displaying elements, 137 Download data, 206 Duplicates in a report suppressing them, 150 E Edit option, 15, 135 Edit Tests window, 80, 92 Edit the Display Format window, 139 Element column, 15 Element definition viewing, 194
_new_ezq_reference.docx