IN DEX testing, 171 Foreign keys, 63 Element Definition window, Format, 141 197 Element Description window, types of, 49 55, 58, 183, 186 width of, 144 customizing, 139 ELEMENT Header window, EMPLOYEES tables, A-2 Format prompt, 206 160 End report, 208 Format Sort Element window, Element name prompt, 180 Enter footer text prompt, 220 112, 164 Element Type window, 52 Enter header text prompt, 219 with Footer, 125 Element types, 180 External element, 49, 180 Format the Element window, Element width prompt, adding, 62, 105, 184 26, 38, 111, 138, 163 144 Elements, 24 EZQ Breaks window, 216 Formatting elements, 138 adding, 50, 178, 179, EZQ Create/Copy window, 5, Formatting the sort element, 180 131 164 comparing, 175 EZQ Editor Function element, 49, 180 comparing to a literal, corresponding SQL adding, 181 75, 89 components, 227 of, 49, 53, 56, comparing to another exiting, 18 181, 182 element, 93 how it works, 225 Function keys, 12, 16 data type, 89 how to access the major Functions, 17 deleting, 195 functions, 135 G display sequence, how to quit, 223 displaying in sort starting, 2 Group by Element window, header, 110 EZQ Editor interface, 9 47, 168 displaying null values, EZQ prompts prompt, 219 column, 15, 47, 167 151 EZQ Tests window, 209 input functions, 167 displaying them, 23, EZQ window, 12, 13, 18 Group elements 24, access to it, 135 creating them, 47 136, 137 exiting, 18 Grouping editing the definition, F as opposed to sorting, 196 167, 169 editing the display File example of, 169 format, 139 output to, 206 external, 61 H footer, 215 formatting, 38, 138 creating, 122 grouping, 167, 168 Header Event window, 109, Footer link, 63 157 entering text for, 220 placement of in the Header text final, 122 report, 143 in Page Header formatting sort footers, primary, 178 window, 120 215 sorting them, 28, 152, Header text line 1 prompt, modifying, 217 154, 155 116 Footer Event window, 123 target, 65
IN DEX Element Definition window, 197 Element Description window, 55, 58, 183, 186 ELEMENT Header window, 160 Element name prompt, 180 Element Type window, 52 Element types, 180 Element width prompt, 144 Elements, 24 adding, 50, 178, 179, 180 comparing, 175 comparing to a literal, 75, 89 comparing to another element, 93 data type, 89 deleting, 195 display sequence, displaying in sort header, 110 displaying null values, 151 displaying them, 23, 24, 136, 137 editing the definition, 196 editing the display format, 139 external, 61 formatting, 38, 138 grouping, 167, 168 link, 63 placement of in the report, 143 primary, 178 sorting them, 28, 152, 154, 155 target, 65 testing, 171 types of, 49 width of, 144 EMPLOYEES tables, A-2 End report, 208 Enter footer text prompt, 220 Enter header text prompt, 219 External element, 49, 180 adding, 62, 105, 184 EZQ Breaks window, 216 EZQ Create/Copy window, 5, 131 EZQ Editor corresponding SQL components, 227 exiting, 18 how it works, 225 how to access the major functions, 135 how to quit, 223 starting, 2 EZQ Editor interface, 9 EZQ prompts prompt, 219 EZQ Tests window, 209 EZQ window, 12, 13, 18 access to it, 135 exiting, 18 F File output to, 206 footer, 215 creating, 122 Footer entering text for, 220 final, 122 formatting sort footers, 215 modifying, 217 Footer Event window, 123 Foreign keys, 63 Format, 141 customizing, 139 Format prompt, 206 Format Sort Element window, 112, 164 with Footer, 125 Format the Element window, 26, 38, 111, 138, 163 Formatting elements, 138 Formatting the sort element, 164 Function element, 49, 180 adding, 181 of, 49, 53, 56, 181, 182 Function keys, 12, 16 Functions, 17 G Group by Element window, 47, 168 column, 15, 47, 167 input functions, 167 Group elements creating them, 47 Grouping as opposed to sorting, 167, 169 example of, 169 H Header Event window, 109, 157 Header text in Page Header window, 120 Header text line 1 prompt, 116