Skip Headers

Oracle Discoverer Desktop User's Guide 10g (9.0.4) for Windows Part Number B10272-01 |
Home |  | Contents

# 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

| Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
|  | Contents