IN DEX window, 54, 183 selecting, 131 Select Table window, 132 using for summaries, Target element, 65 Select Target Element 152, 156 selecting, 186 window, 65, 186 Sort header, 110, 215 TASKS table, A-4 Select Test Type window, 74, displaying elements in, Test column, 15, 73, 171 161 174 as opposed to the Tests Select USER OPTIONS displaying it, 156 option, 209 formatting, 111 window, 2 input functions, 172 Selection windows, 11 for titles, 152, Test Selection window, 77 Sequence number, 136 156 Test this Element window, Sort level, 29, 152 Setup option, 33, 201, 205 73, and the Show SQL highest, 154 173 Sort Level window, 29, 154 prompt, 200 Test 74 Tests Parameters window, 33, Sorting applied to elements, 34, 35, 205 as opposed to grouping, 171 167 Setup prompt, 204 combining pairs of, 84 Show EZQ data prompt, 203 query results, 28, 107 creating multiple, 78 Source elements, 54, 183 Show SQL prompt, 34, 35, example of, 177 207 Spacing prompt, 221 handling multiple, 82 Show SQL text prompt, 203 SQL_IDENTIFIER, 141 modifying, 209 Skip lines after event prompt, definition of, 129 pairs of, 212 158 SQL Command window, 200 removing, 80, 92 SQL expression Skip lines before event specifying, 73 prompt, 158 as part of calculation of, 174 element, 192, 193 Skip lines prompt, 112, 166 using calculation Sort by Element window, 28, SQL Expression window, 190 elements, 192 107, 114, 153 SQL statements viewing, 209 displaying, 34, 35 Sort column, 15, 28, 152 option, 73, 84, 209 input functions, 152 viewing them, 200 and using the scratch Stats prompt, 207 Sort direction, 30 pad, 210 Sort direction prompt, 155 Suppress duplicates prompt, prompt, 204 Sort Direction window, 30, 150 Text windows, 10 155 T Text wrap options, 147 Sort element, 215 examples of, 148 defining a second one, Tab position, 142, 143 Top margin prompt, 221 114 Tab position prompt, 116 Total all values function, 156 formatting, 163 in Format Sort Element Total distinct values selecting for display in window, 166 function, sort header, 162 Tables 156 Sort Element window, 162 demonstration tables, Type prompt Sort footer, 215 A-1 - A-4 of dash line after, 159 displaying it, 156
IN DEX window, 54, 183 Select Table window, 132 Select Target Element window, 65, 186 Select Test Type window, 74, 174 Select USER OPTIONS window, 2 Selection windows, 11 Sequence number, 136 Setup option, 33, 201, 205 and the Show SQL prompt, 200 Parameters window, 33, 34, 35, 205 Setup prompt, 204 Show EZQ data prompt, 203 Show SQL prompt, 34, 35, 207 Show SQL text prompt, 203 Skip lines after event prompt, 158 Skip lines before event prompt, 158 Skip lines prompt, 112, 166 Sort by Element window, 28, 107, 114, 153 Sort column, 15, 28, 152 input functions, 152 Sort direction, 30 Sort direction prompt, 155 Sort Direction window, 30, 155 Sort element, 215 defining a second one, 114 formatting, 163 selecting for display in sort header, 162 Sort Element window, 162 Sort footer, 215 displaying it, 156 using for summaries, 152, 156 Sort header, 110, 215 displaying elements in, 161 displaying it, 156 formatting, 111 for titles, 152, 156 Sort level, 29, 152 highest, 154 Sort Level window, 29, 154 Sorting as opposed to grouping, 167 query results, 28, 107 Source elements, 54, 183 Spacing prompt, 221 SQL_IDENTIFIER, 141 definition of, 129 SQL Command window, 200 SQL expression as part of calculation element, 192, 193 SQL Expression window, 190 SQL statements displaying, 34, 35 viewing them, 200 Stats prompt, 207 Suppress duplicates prompt, 150 T Tab position, 142, 143 Tab position prompt, 116 in Format Sort Element window, 166 Tables demonstration tables, A-1 - A-4 selecting, 131 Target element, 65 selecting, 186 TASKS table, A-4 Test column, 15, 73, 171 as opposed to the Tests option, 209 input functions, 172 Test Selection window, 77 Test this Element window, 73, 173 Test 74 Tests applied to elements, 171 combining pairs of, 84 creating multiple, 78 example of, 177 handling multiple, 82 modifying, 209 pairs of, 212 removing, 80, 92 specifying, 73 of, 174 using calculation elements, 192 viewing, 209 option, 73, 84, 209 and using the scratch pad, 210 prompt, 204 Text windows, 10 Text wrap options, 147 examples of, 148 Top margin prompt, 221 Total all values function, 156 Total distinct values function, 156 Type prompt of dash line after, 159
_new_ezq_reference.docx