Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Symbols
- != operator in conditions, 1
- & (ampersand) in worksheet titles, 1
- + (plus) sign in dialog boxes, 1
- < operator in conditions, 1
- <= operator in conditions, 1
- <> operator in conditions, 1
- = operator in conditions, 1
- > operator in conditions, 1
- >= operator in conditions, 1
Numerics
- 3D graphs, 1
- 3D View command, 1
A
- access rights, 1
- accessing data, 1,
2
- accessing workbooks, 1
- active folder, 1
- Active Only option, 1,
2
- adding graphic bars, 1,
2
- adding graphics to worksheets, 1,
2
- adding new items to layouts, 1,
2
- adding reports, 1
- addition, 1
- administrators, 1,
2
- Advanced button (Conditions), 1,
2
- aggregations icon, 1
- aligning
- bitmaps in titles, 1
- report headers/footers, 1
- text in column headings, 1
- All Items option, 1,
2
- ampersand (&) in worksheet titles, 1
- analysis bar, 1
- analysis tools
- applying to data, 1,
2
- creating definitions, 1
- deleting definitions, 1
- editing definitions, 1
- exporting and, 1
- turning definitions on/off, 1
- viewing definitions, 1
- Analytic Functions, 1,
2
- and Oracle Server 8.1.6, 1
- and Sequencing, 1
- calculating cumulative values, 1
- CASE, 1
- categories, 1
- Equi-height bands, 1
- equi-height bands, 1
- generic template, 1
- in Conditions, 1
- INTERCEPT, 1
- Lag/Lead, 1
- LEAD, 1
- ORDER BY expression, 1
- OVER expression, 1
- PARTITION BY expression, 1
- RANK(), 1,
2
- Ranking, 1
- RATIO_TO_REPORT, 1
- REGR_AVGX, 1
- REGR_COUNT, 1
- REGR_R2, 1
- Reporting, 1
- SUM, 1,
2
- Windowing with logical offsets, 1
- Windowing with physical offsets, 1
- analyzing data, 1,
2,
3
- AND operator, 1
- and Responsibilities, 1
- applications, 1
- Apply group sort icon, 1
- applying formats, 1
- arrows as cursors, 1,
2
- ascending sort order, 1
- assigning workbooks, 1,
2
- associating data with workbooks, 1
- attaching to databases, 1
- attachments, 1
- audio files, 1
- Auto Size command, 1
- Average option, 1
- averages, 1,
2
- axes labels (graphs)
- displaying, 1,
2,
3
- formatting, 1
- axis item icon, 1
- axis item markers, 1,
2
- selecting, 1
- axis item value icon, 1
- axis items, 1
- crosstabs, 1
- drilling into, 1,
2
- drilling through sub-levels on, 1
- moving data among, 1,
2
- selecting, 1,
2,
3
- sorting across, 1
- sorting on, 1,
2
- viewing values, 1
- workbook window, 1
B
- background colors
- column headings, 1
- worksheet titles, 1
- Banding
- Banding by rank, 1
- Banding by value, 1
- CASE, 1
- with Analytical Functions, 1
- bar formats
- graphs, 1
- tables, 1
- BETWEEN operator, 1
- bitmaps, 1,
2
- Boolean operators, 1
- Business area icon, 1
- business areas, 1
- displaying, 1
- selecting items, 1,
2
- buttons
- Graph toolbar, 1
- Print Preview window, 1
- workbook window, 1
- bypassing the Connect dialog, 1
C
- cache, 1
- Calculation dialog box, 1
- Calculation Examples, 1
- calculations, 1,
2,
3
- creating, 1,
2
- creating for conditions, 1
- displaying results, 1
- editing in new workbooks, 1
- exporting and, 1
- selecting for new workbooks, 1
- standard syntax, 1,
2,
3,
4
- viewing existing, 1
- Calculations command, 1
- Calculations dialog box, 1
- canceling changes, 1
- case-sensitive text filters, 1
- cell spacing, 1
- cells
- drilling and, 1
- selecting, 1,
2
- changing data, 1
- changing data formats, 1
- changing graphs, 1,
2
- changing pages
- multi-page layouts, 1
- workbooks, 1
- changing text items, 1,
2
- clock icon, 1
- Close command, 1
- closing Print Preview window, 1
- closing workbooks, 1
- Collapse command, 1
- colors
- column headings, 1
- graphs, 1,
2
- customizing, 1,
2
- worksheet titles, 1
- column headings, 1,
2,
3,
4
- aligning text, 1
- display options, 1
- drilling and, 1
- editing text, 1
- formatting caution, 1
- reformatting on crosstabs, 1
- reformatting on tables, 1,
2
- selecting, 1
- wrapping text in, 1
- column markers, 1,
2
- columns, 1,
2
- displaying text, 1
- drilling multiple, 1
- moving, 1,
2
- group sorts and, 1
- pivoting, 1,
2,
3
- reformatting data, 1
- removing from sorts, 1
- resizing, 1,
2
- automatically, 1
- selecting, 1
- selecting items, 1
- sorting on two, 1
- Columns Width command, 1
- Command Line Interface, 1
- command-line options, 1
- company logos, 1
- comparisons, 1,
2,
3
- complex calculations, 1
- complex conditions, 1
- condition
- parameter placeholder, 1
- condition icon, 1
- condition operators, 1
- conditions, 1,
2,
3
- adding descriptions to, 1
- applying, 1,
2
- assigning data items to, 1,
2
- changing on new worksheets, 1
- conflicting, 1
- copying, 1
- creating advanced, 1,
2
- creating definitions for, 1,
2
- deleting definitions, 1,
2
- editing definitions, 1
- enabling/disabling definitions, 1,
2
- exceptions vs., 1
- exporting and, 1
- naming, 1
- nesting, 1
- removing, 1
- selecting, 1
- selecting for new worksheets, 1
- selecting multiple values for, 1
- viewing definitions
- for specific items, 1
- Conditions command, 1
- Conditions dialog box, 1
- Configuring Discoverer to use standard EULs, 1
- Configuring the Oracle Applications user Connect dialog, 1
- Connect to Discoverer dialog box, 1
- connecting to databases, 1
- Copy Graph to Clipboard button, 1
- copying conditions, 1
- copying SQL statements, 1
- correlated items, 1,
2
- correlation, 1
- Count All Rows command, 1
- Count Distinct option, 1
- Count option, 1
- covariance, 1
- Create Calculation option, 1
- Create Subquery dialog box, 1
- creating calculations, 1,
2
- creating graphs, 1,
2,
3
- creating reports, 1
- creating workbooks, 1
- creating workbooks and worksheets, 1,
2,
3
- arranging layouts, 1
- choosing data items, 1,
2
- optional steps, 1
- selecting conditions, 1
- selecting display type, 1
- sorting data, 1
- specifying calculations, 1
- crosstabs, 1,
2,
3
- arranging items on new, 1
- data points and, 1
- delineating data, 1,
2
- drilling and, 1
- multiple columns or rows, 1,
2
- procedure described, 1
- skipping hierarchical levels, 1,
2
- duplicating, 1
- editing layouts, 1,
2
- getting data for new, 1
- item markers and, 1,
2
- larger than a page, 1
- overview, 1
- pivoting items, 1
- reformatting column headings, 1
- reformatting data, 1
- scaling, 1
- selecting as display type, 1
- selecting items, 1,
2,
3
- sorting data, 1,
2
- across axes, 1
- adding data points, 1
- defaults, 1
- group sorts and, 1
- restoring previous state, 1
- with multiple pages, 1,
2
- current date, 1,
2
D
- data, 1
- accessing, 1,
2
- adding to graphs, 1
- aggregating, 1
- analyzing, 1,
2,
3
- canceling changes, 1
- comparing, 1,
2,
3
- delineating with bars, 1,
2
- displaying specific items, 1,
2
- filtering, 1,
2,
3
- finding exceptions, 1,
2
- defining item for, 1
- getting details, 1
- pivoting, 1,
2,
3
- on crosstabs, 1
- reformatting, 1,
2
- replacing, 1
- retrieving, 1,
2,
3
- for new crosstabs, 1
- saving changes to, 1
- selecting for drilling, 1
- automatically, 1
- in other sheets, 1
- tables, 1
- selecting for new worksheets, 1,
2
- sorting, 1,
2,
3
- automatically, 1
- crosstabs and, 1,
2,
3
- data within, 1,
2
- display options, 1
- in groups, 1,
2,
3
- on new worksheets or workbooks, 1,
2,
3
- subtotals and ungrouped, 1
- totals for non-numeric, 1
- updating, 1
- viewing, 1,
2,
3,
4
- Data command, 1
- data points, 1
- calculations and, 1
- defined, 1
- getting totals for, 1,
2,
3
- sorting, 1
- databases, 1,
2,
3
- connecting to, 1
- loading, 1
- non-Oracle, 1
- saving workbooks with, 1
- dates
- adding to reports, 1,
2
- setting for scheduled reports, 1
- decimal places, 1,
2
- default aggregate, 1
- default formats, 1
- Define Custom Colors option, 1
- Delete button, 1
- Delete command, 1
- Delete Workbook from Database dialog, 1
- deleting
- analysis tool definitions, 1
- items from workbooks and worksheets, 1
- items on new worksheets, 1
- sort columns, 1
- workbooks, 1
- descending sort order, 1
- descriptions for workbooks, 1
- designing reports, 1
- dimensions, 1,
2
- Discoverer
- running, 1
- Discoverer Desktop
- basic concepts, 1
- shortcuts, 1
- disk cache, 1
- display options, 1
- display types, 1,
2
- selecting, 1
- displaying
- business areas, 1
- data, 1,
2,
3,
4
- specific items, 1,
2
- graph labels, 1,
2,
3
- graphs, 1
- items in folders, 1
- multi-page reports, 1
- page headers/footers, 1
- sorted data, 1
- SQL statements, 1,
2
- text, 1
- workbooks, 1
- worksheets, 1
- distinct values, 1
- distributing reports, 1,
2
- donut graphs, 1
- double-headed cursors, 1
- Drill command, 1
- Drill dialog box, 1,
2
- opening, 1
- drill options, 1,
2
- from menus, 1
- Drill Options dialog box, 1
- drilling, 1,
2
- across worksheets, 1,
2
- automatically, 1
- basic procedure described, 1
- crosstabs and, 1
- data out of sequence, 1,
2
- display options, 1
- tables and, 1,
2,
3,
4
- to related items, 1,
2,
3
- drilling menus, 1
- Duplicate as Table dialog box, 1
- duplicate rows, 1
- duplicate values, 1
- duplicating tables and crosstabs, 1
E
- Edit Calculation dialog box, 1,
2
- Edit Condition dialog box, 1
- Edit Graph command, 1
- Edit Parameter Values command, 1
- Edit Sheet command, 1
- Edit Sheet dialog box, 1
- adding/removing items, 1
- changing conditions, 1
- changing layouts, 1
- changing sorting preferences, 1
- edit subquery, 1
- Edit Title command, 1,
2,
3
- Edit Title dialog box, 1,
2,
3
- Insert button, 1
- editing
- analysis tool definitions, 1
- column headings, 1
- exception items, 1
- graphs, 1,
2
- new worksheets and workbooks, 1,
2
- scheduled report settings, 1,
2
- worksheet titles, 1
- editing subqueries, 1
- e-mail, 1,
2
- adding attachments, 1
- format options, 1
- equal values, 1
- equality, 1
- error messages, 1
- EUL (End User Layer), 1
- Excel tool, 1
- Excel workbooks, 1,
2
- Exception dialog box, 1,
2
- exceptions, 1,
2
- conditions vs., 1
- conflicts, 1
- creating, 1,
2
- defining expressions, 1,
2
- editing, 1
- enabling/disabling, 1,
2
- formatting, 1
- Exceptions command, 1
- Exceptions dialog box, 1
- opening, 1
- Exceptions tool, 1
- Execution Plan
- Materialized Views, 1
- expanding items in dialog boxes, 1
- expiration dates, 1
- Export command, 1,
2
- Export dialog box, 1
- for Oracle Reports, 1
- Export SQL from a Workbook, 1
- exporting reports, 1
- exporting SQL statements, 1
- expressions, 1
- defining for conditions, 1,
2,
3,
4
- defining for exceptions, 1,
2
- external applications, 1,
2
F
- files, 1
- filters, 1,
2,
3
- Find button, 1
- finding
- exceptions to data values, 1
- specific text items, 1
- flattened SQL, 1
- folders, 1
- active vs. unavailable, 1
- viewing items, 1
- Folders icon, 1
- fonts
- column headings, 1
- graphs, 1
- report headers/footers, 1
- footers, 1,
2
- adding text codes, 1
- Format Data dialog box, 1
- Format Heading dialog box, 1
- Format Title dialog box, 1
- formatting axes labels, 1
- formatting bar, 1
- reformatting column headings, 1,
2
- formatting options
- bitmaps, 1
- exceptions, 1
- percentages, 1
- totals and subtotals, 1
- worksheet titles, 1
- formatting worksheets, 1,
2
- column headings, 1,
2
- titles, 1
- Foundation Name, 1
G
- Gateway User ID, 1
- Generate Label Automatically option, 1
- Graph button, 1
- Graph menu, 1
- Graph window, 1
- resizing, 1
- Graph Wizard, 1,
2,
3
- graphic bars, 1,
2
- graphics, 1,
2
- graphs, 1,
2
- adding legends, 1
- adding patterns, 1,
2
- adding to worksheets, 1,
2,
3
- color options, 1
- display options, 1
- distributing via e-mail, 1,
2
- modifying, 1,
2
- plotting data on, 1
- printing, 1,
2
- removing patterns, 1
- resizing, 1
- rotating, 1
- z-axis, 1
- selecting type, 1,
2,
3
- updating, 1
- visual enhancements, 1,
2
- gridlines, 1,
2
- group names, 1
- group sorts, 1,
2,
3
- automatic, 1
H
- headers, 1,
2
- adding text codes, 1
- Headings command, 1,
2
- Hi to Lo sort order, 1
- hiding duplicate rows, 1
- high values, 1,
2,
3
- highlighting, 1
- hints, 1
- HKEY_CURRENT_USER - registry setting, 1
- horizontal gridlines, 1
I
- icons (New Sheet dialog), 1,
2
- 1
- Import SQL command, 1
- importing SQL, 1
- importing SQL statements, 1
- IN operator, 1
- informational messages, 1
- Inline Views, 1
- Insert Data Point Name option, 1,
2
- Insert Item Name option, 1,
2
- Insert menu, 1
- Insert Value option, 1,
2
- IS NOT NULL operator, 1
- IS NULL operator, 1
- item handles, 1
- item markers, 1,
2
- selecting, 1
- items, 1
- adding new, 1,
2
- adding to printed reports, 1
- arranging in layouts, 1,
2
- attaching to conditions, 1
- deleting on new worksheets, 1
- editing, 1,
2
- expanding in dialog boxes, 1
- formatting, 1,
2
- pivoting on crosstabs, 1
- pivoting on tables, 1,
2
- removing from workbooks and worksheets, 1
- selecting, 1
- in multiple positions, 1
- selecting for exceptions, 1
- selecting for scheduled reports, 1,
2
- viewing conditions for specific, 1
- viewing in folders, 1
J
- join definitions - importing SQL, 1
L
- labels, 1
- adding text codes
- percentages and, 1
- totals and subtotals, 1
- displaying on graphs, 1,
2,
3
- formatting graph axes, 1
- generating automatically, 1
- percentages columns, 1,
2
- removing text codes, 1,
2
- wrapping text in, 1
- Landscape mode, 1
- large worksheets, 1
- layout options, 1
- layouts, 1,
2
- arranging items, 1,
2
- changing, 1,
2
- selecting, 1
- Legend command, 1
- legends, 1
- adding to graphs, 1
- displaying, 1,
2
- LIKE operator, 1
- linear regression, 1
- lines, 1,
2,
3
- lists, 1,
2
- Lo to Hi sort order, 1
- loading databases, 1
- logos, 1
- Lotus 1-2-3 spreadsheet, 1
- low values, 1,
2,
3
M
- magnifying glass, 1
- mailing lists, 1
- main window, 1
- margins, 1
- Match Case option, 1
- Materialized View, 1
- mathematical functions
- selecting, 1
- Maximum option, 1
- memory cache, 1
- menus, 1,
2
- drilling options, 1
- metafiles, 1
- Microsoft Excel workbooks, 1,
2
- Minimum option, 1
- Modify Graph button, 1,
2
- Modify Graph dialog box, 1
- monthly reports, 1
- moving columns, 1,
2
- group sorts and, 1
- 1
- multi-dimensional crosstabs, 1
- multi-page crosstabs, 1
- changing pages, 1
- multi-page reports, 1
- multi-page tables, 1
- changing pages, 1
- multiple columns or rows
- drilling, 1,
2
- multiple workbooks
- opening, 1,
2
- switching among, 1
N
- nesting conditions, 1
- New command, 1
- New Condition dialog box, 1,
2
- New Graph Type button, 1,
2
- New Graph Type drop down list, 1
- New Parameter command, 1
- New Parameter dialog box, 1
- new sheet
- for subqueries, 1
- New Sheet command, 1
- New Sheet dialog box, 1
- arranging items on layouts, 1
- icons described, 1,
2
- moving items to Selected list, 1
- opening, 1
- selecting calculations, 1
- setting conditions, 1
- sorting data, 1
- non-numeric data totals, 1
- non-Oracle databases, 1,
2
- NOT BETWEEN operator, 1
- NOT IN operator, 1
- NOT LIKE operator, 1
- null values, 1
- numbers, 1,
2
- adding graphic bars, 1,
2
- adding to new crosstabs, 1
- getting exceptions to, 1
- getting totals and subtotals for, 1,
2
- sorting, 1,
2,
3
- numeric item icon, 1
O
- OLE automation, 1
- OLE support in Discoverer, 1
- One Page button, 1
- on-line transaction processing, 1
- /open option, 1
- Open command, 1
- /open option, 1
- Open Scheduled Workbook dialog box, 1
- Open Workbook dialog box, 1
- opening Scheduling Manager, 1
- opening workbooks, 1,
2,
3,
4
- multiple, 1,
2
- non-Oracle, 1
- operator buttons, 1
- operators, 1
- Boolean, 1
- conditional expressions, 1
- Options button, 1
- Options command, 1
- Options dialog box, 1,
2
- Oracle Applications
- automatic Connect, 1
- choosing a Responsibility, 1
- configuring the Connect dialog, 1
- Connect dialog, 1
- connect to Discoverer, 1
- connection configuration, 1
- Foundation Name, 1
- Gateway User ID, 1
- Prerequisites, 1
- shortcut icon, 1
- supported features, 1
- Oracle Applications User, 1
- Oracle Reports, 1,
2
- ordered lists, 1
- Orientation option, 1
- outlined cells, 1
P
- /p <file> option, 1
- page axis, 1
- containing data, 1
- moving columns to, 1,
2
- page detail crosstab layouts, 1
- changing pages, 1
- page detail tabular layouts, 1
- changing pages, 1
- page headers and footers, 1,
2
- adding text codes, 1
- page item marker, 1
- page items
- editing, 1
- pivoting, 1
- reformatting, 1
- removing from layouts, 1
- page numbers, 1
- page orientation, 1
- Page Setup command, 1
- Page Setup dialog box, 1,
2
- opening, 1
- pagebreaks, 1
- paint jar, 1
- Parameter dialog box, 1
- parameters
- adding to conditions, 1
- attaching to conditions, 1
- calculations and, 1
- creating, 1,
2
- defined, 1
- defining default, 1
- enabling/disabling, 1
- entering multiple values in, 1,
2
- naming, 1
- selecting data items for, 1
- viewing existing, 1
- Parameters command, 1
- Parameters dialog box, 1
- passwords, 1
- Pattern Editor, 1
- patterns, 1
- adding to graphs, 1,
2
- customizing, 1
- removing from graphs, 1
- pencil tool, 1
- Percentage dialog box, 1
- Percentage of Grand Total option, 1
- percentages, 1
- creating definitions for, 1
- editing definitions, 1
- enabling/disabling definitions, 1
- formatting options, 1
- getting, 1
- group sorts and, 1
- not totaling 100%, 1
- removing, 1
- rounding and, 1
- viewing definitions, 1
- percentages columns
- labeling, 1,
2
- Percentages command, 1
- Percentages dialog box, 1
- opening, 1
- Percentages tool, 1
- pie graphs, 1
- pivoting, 1,
2,
3
- examples, 1,
2,
3
- items on crosstabs, 1
- items on tables, 1,
2
- plus signs (+) in dialog boxes, 1
- pointers
- as arrows, 1,
2
- as double-headed lines, 1
- as magnifying glass, 1
- as paint jar, 1
- as pencil, 1
- item markers and, 1
- page axis and, 1
- pop-up menus, 1
- Portrait mode, 1
- preface
- conventions table sample, 1
- heading
- PH PrefaceHead, 1
- PT PrefaceTitle, 1
- Prepare Mail dialog box, 1
- Preview button, 1,
2
- previewing reports, 1,
2
- Print button, 1
- print options, 1,
2
- Print Preview command, 1
- Print Preview window, 1
- closing, 1
- moving through report pages, 1
- printing, 1,
2
- from files, 1
- graphs, 1,
2
- large worksheets, 1
- reports, 1,
2,
3
- progressions, 1
- prompts, 1
- properties, 1,
2
- Properties command, 1
- PT PrefaceTitle, 1
Q
- queries, 1,
2,
3
- running, 1
- running for all sheets, 1
- query estimate dialog, 1
- Query Governor, 1
R
- RANK
- default ordering, 1
- ordering by ASC, 1
- ordering by DESC, 1
- RDF files, 1
- rearranging columns, 1,
2
- group sorts and, 1
- reference lines (graphs), 1
- reformatting worksheets, 1,
2
- column headings, 1,
2
- titles, 1
- Refresh Sheet command, 1,
2
- refreshing worksheets, 1
- regedit, 1
- registry settings, 1
- removing items from workbooks and worksheets, 1
- removing sort columns, 1
- removing workbooks, 1
- renaming workbooks, 1
- reordering columns, 1,
2
- group sorts and, 1
- replacing data, 1
- report templates (Oracle Reports), 1
- reports, 1,
2
- adding date/time entries, 1,
2
- adding headers/footers, 1
- designing page layouts, 1
- displaying two pages side-by-side, 1
- distributing with e-mail, 1,
2
- exporting, 1
- previewing, 1,
2
- printing, 1,
2,
3
- removing headers/footers, 1
- running scheduled, 1,
2
- saving, 1
- setting margins, 1
- unscheduling, 1
- viewing multi-page, 1
- resizing columns, 1,
2
- automatically, 1
- resizing graphs, 1
- resizing windows, 1
- result sets, 1,
2
- selecting, 1
- viewing, 1
- Retrieve All Rows command, 1
- retrieving rows, 1
- right-click menus, 1
- rotating graphs, 1
- rounding, 1
- row markers, 1
- row numbers, 1,
2
- rows, 1
- drilling multiple, 1,
2
- drilling single, 1,
2
- hiding duplicate, 1
- retrieving, 1
- selecting, 1
- running Discoverer, 1
- running queries, 1
- running scheduled reports, 1,
2
S
- sample database, 1,
2
- Save As command, 1
- Save As dialog box, 1
- Save command, 1
- Save Workbook dialog box, 1
- Save Workbook to Database dialog box, 1
- saving exported reports, 1
- saving workbooks, 1,
2
- Scale command, 1
- scaling printouts, 1
- Schedule button, 1,
2
- Schedule command, 1
- Schedule Workbook dialog box, 1,
2,
3,
4
- opening, 1
- scheduled reports, 1,
2
- deleting completed, 1
- displaying, 1
- editing settings, 1,
2
- error messages, 1
- expiration dates, 1
- naming, 1
- running, 1,
2
- selecting items, 1,
2
- unscheduling, 1
- viewing results, 1,
2,
3
- Scheduled Workbook
- Oracle Applications User, 1
- scheduled workbooks, 1,
2
- Oracle Applications Users, 1
- Scheduling Manager, 1,
2
- opening, 1
- Scheduling Manager button, 1
- Scheduling Manager command, 1
- screen markers, 1,
2,
3
- scroll bars, 1
- scroll buttons, 1,
2
- scrolling, 1
- Select Condition option, 1
- selecting
- data for drilling, 1
- automatically, 1
- in other sheets, 1
- tables, 1
- data for new worksheets, 1,
2
- display type, 1
- exception items, 1
- items for scheduled reports, 1,
2
- items on worksheets, 1
- in multiple positions, 1
- multiple values for conditions, 1
- result sets, 1
- workbooks, 1,
2
- worksheets, 1,
2,
3
- selection boxes, 1,
2
- Send command, 1
- sending e-mail messages, 1
- sequential conditions, 1
- servers, 1
- Set Bitmap option, 1
- setting options, 1
- setting properties
- workbooks, 1,
2
- setting report margins, 1
- setting sort order, 1,
2
- shading, 1
- shadows, 1
- Share Workbooks dialog box, 1,
2
- Sharing command, 1
- sharing workbooks, 1,
2
- /sheet ALL option, 1
- shortcuts, 1
- Show Graphic Bars option, 1
- Show Page Items option, 1
- Show/Hide Labels button, 1,
2,
3
- Show/Hide Legend button, 1,
2
- simple calculations, 1,
2
- Sort command, 1,
2
- Sort Crosstab dialog box, 1,
2
- opening, 1
- sort order, 1,
2
- reversing, 1
- Sort Table dialog box, 1
- ordering columns in, 1
- sorting data, 1,
2,
3
- adding sort columns, 1,
2
- automatically, 1
- crosstabs and, 1,
2,
3
- display options, 1
- group sorting and, 1,
2,
3
- on new worksheets or workbooks, 1,
2,
3
- removing columns, 1
- sorting options, 1,
2
- sorting tools, 1
- crosstabs and, 1
- spacing, 1
- spreadsheets, 1,
2
- SQL Inspector
- Execution Plan, 1
- SQL Inspector command, 1,
2
- SQL program - importing, 1
- SQL statements, 1
- SQL syntax, 1
- SQLType - registry setting, 1
- standard deviation, 1
- calculating, 1
- Standard Deviation option, 1
- starting
- Discoverer Desktop, 1
- Statistics, 1
- status bar, 1
- Status Bar command, 1
- subqueries, 1
- edit, 1
- new workbooks, 1
- subqueries, correlated items, 1
- subqueries, creating, 1
- subtotals, 1,
2
- adding lines to, 1
- getting, 1,
2
- getting percentages for, 1
- placement options, 1
- removing, 1
- ungrouped data and, 1
- viewing definitions, 1
- Sum option, 1
- summaries, 1
- sums, 1,
2
- suqueries
- editing, 1
T
- table
- larger than a page, 1
- tables, 1,
2,
3,
4
- arranging items on new, 1
- changing sorting preferences, 1
- data points and, 1
- delineating data, 1,
2
- drilling and, 1,
2,
3,
4
- procedure described, 1
- skipping hierarchical levels, 1,
2
- duplicating, 1
- editing layouts, 1,
2
- item markers and, 1
- layout options, 1
- moving columns, 1,
2
- group sorts and, 1
- pivoting items, 1,
2
- reformatting column headings, 1,
2
- reformatting data, 1
- resizing columns, 1,
2
- automatically, 1
- retrieving rows, 1
- scaling, 1
- selecting as display type, 1
- selecting items, 1,
2,
3
- sorting data, 1,
2
- automatically, 1
- with multiple pages, 1,
2
- tabs, 1,
2
- templates (Oracle Reports), 1
- text
- aligning
- in column headings, 1
- case-sensitive filters, 1
- data points and totals for, 1
- defining conditions for, 1
- editing, 1,
2
- finding specific, 1
- getting exceptions to, 1
- mathematical functions and, 1
- resizing columns and, 1
- sorting, 1,
2,
3
- word wrapping, 1,
2
- text codes
- adding to labels
- percentages columns, 1
- totals and subtotals, 1
- removing, 1,
2
- report headers/footers, 1
- Text Wrap button, 1
- three-dimensional graphs, 1
- time estimate dialog, 1
- time limit warnings, 1
- time settings for scheduled reports, 1
- time stamps, 1
- Title command, 1
- titles
- adding bitmaps, 1
- adding to graphs, 1,
2
- editing, 1
- formatting, 1,
2
- totals and subtotals, 1
- tool bar
- Graph window, 1
- Print Preview window, 1
- tool tips, 1
- Toolbar command, 1
- Total dialog box, 1
- totals, 1,
2,
3,
4
- adding lines to, 1
- creating definitions for, 1
- editing definitions, 1
- enabling/disabling definitions, 1
- entering labels for, 1
- finding percentages of, 1
- formatting options, 1
- getting percentages for, 1
- placement options, 1
- removing, 1
- viewing definitions, 1
- Totals command, 1
- Totals dialog box, 1
- Totals tool, 1
- options, 1
- transaction processing, 1
- trends, 1
- truncated text, 1
- Two Page button, 1
U
- unavailable folders, 1
- unique values, 1
- Unschedule button, 1
- updating graphs, 1
- updating worksheets, 1
- User -> Workbook tab, 1
- user names, 1
V
- Value(s) option (Conditions), 1,
2
- values, 1
- counting unique, 1
- creating conditions for, 1
- getting exceptions to, 1,
2
- defining expressions for, 1
- getting totals and subtotals for, 1
- null, 1
- selecting multiple for conditions, 1
- sorting and duplicate, 1
- viewing for zxis items, 1
- variables, 1
- Variance option, 1
- vertical gridlines, 1
- Video database, 1
- video files, 1
- View Conditions For option, 1
- View Errors option, 1
- Viewer checkboxes, 1
- viewing
- business areas, 1
- data, 1,
2,
3,
4
- specific items, 1,
2
- file types, 1
- graph labels, 1,
2,
3
- graphs, 1
- items in folders, 1
- multi-page reports, 1
- page headers/footers, 1
- sorted data, 1
- SQL statements, 1,
2
- text, 1
- workbooks, 1
- worksheets, 1
- views, 1
W
- weekly reports, 1
- "what if" scenarios, 1
- Window menu, 1
- wizards
- for creating graphs, 1
- for creating workbooks, 1
- for opening workbooks, 1
- WMF formats, 1
- Workbook -> User tab, 1
- Workbook Properties dialog box, 1
- workbook window, 1,
2
- display types, 1,
2,
3
- resizing, 1
- Workbook Wizard, 1,
2
- workbooks, 1
- accessing, 1
- assigning to users, 1,
2
- associating data with, 1
- canceling changes, 1
- closing, 1
- creating, 1,
2,
3,
4
- optional steps, 1
- creating subqueries, 1
- defined, 1
- deleting, 1
- getting information about, 1
- identifying location, 1
- opening, 1,
2,
3,
4
- multiple, 1,
2
- non-Oracle, 1
- reformatting, 1,
2
- removing items, 1
- renaming, 1
- saving, 1,
2
- selecting, 1,
2
- selecting data, 1
- selecting display types for new, 1
- selecting multiple items, 1
- setting properties, 1,
2
- sharing, 1,
2
- switching pages, 1,
2,
3
- viewing, 1
- worksheet
- change subquery, 1
- for subqueries, 1
- worksheet tabs, 1,
2
- worksheets, 1,
2
- activating all, 1
- adding bitmaps, 1
- adding graphs, 1,
2,
3
- adding items to new, 1
- changing data, 1
- choosing items, 1
- in multiple positions, 1
- creating, 1,
2,
3
- optional steps, 1
- deleting items on new, 1
- distributing via e-mail, 1
- drilling across, 1,
2
- editing new, 1,
2
- editing titles, 1
- formatting items, 1,
2
- identifying workbook location, 1
- large, 1
- printing large, 1
- refreshing, 1
- removing items, 1
- replacing data, 1
- retrieving data, 1,
2,
3
- for new crosstabs, 1
- scheduled reports and, 1
- selecting, 1,
2,
3
- selecting data, 1
- selecting display types for new, 1
- selecting multiple items, 1
- viewing, 1
- Wrap Text option, 1,
2
X
- X Labels command, 1
Y
- y-axis scale, 1
- setting, 1,
2
Z
- z-axis, 1
- Zip Codes, 1
- zoom in, 1
- zoom out, 1