## O

#### object

An object is one of several kinds of report elements that generally contain data and have specific properties that define their behavior or appearance. The program uses the following kinds of objects:

- field
- text
- cross-tab
- graph
- subreport
- picture
- OLE.

Each of these objects can be individually formatted, moved, resized, duplicated, and so on.

#### object frame

An object frame is a rectangular cursor that appears as an aid to placing database fields and formulas on your report. Once you have selected a field or created a formula, the object frame appears. When you move the frame to the place in the report you want the field or formula to appear and click the button, the program inserts the item at the point specified.

#### ODBC

ODBC stands for Open Database Connectivity. It is an interface that gives applications the ability to retrieve data in data management systems using SQL for accessing the data. Such an interface allows a developer to develop, compile, and ship applications without targeting specific database management systems. Also called interoperability.

#### OLE

OLE is an acronym for Object Linking and Embedding. It refers to the ability to create compound reports, that is, reports that contain elements from other applications and that can be edited using the original application.

#### OLE container application

An OLE container application is an application that can contain and process OLE objects created elsewhere (like Paint or Paintbrush). Seagate Crystal Reports is a container application.

#### OLE server application

An OLE server application is an application that can create OLE objects that can then be placed in documents created by container applications. Seagate Crystal Reports is a container application, whereas Microsoft Word and Excel are examples of server applications.

#### on-demand subreport

On-demand subreports appear only as hyperlinks in the main report.

The actual data is not read from the database until the user drills down on the hyperlink. Only data for the on-demand subreport that is actually viewed will be retrieved from the database. On-demand subreports may also be called "real time" subreports in some cases.

#### one-to-many

One-to-many refers to a situation occurring in linked databases in which one record in one database can be matched with many records in another database. An example of a one-to-many link would occur when linking a customer table to an orders table. In such a case, for every one customer in the primary database, there would typically be many orders in the second (lookup) database.

#### operator

An operator is a special symbol that describes an operation or an action to take place between two or more values.

The symbol / for example, is an operator that means divide. A/B means Divide A by B. Seagate Crystal Reports reads the operators in a formula and performs the actions specified. Seagate Crystal Reports contains arithmetic, string, comparison, Boolean, conversion, date, and range operators, among others.

#### order of precedence

The order of precedence is a set of rules that determines the order in which arithmetic operations take place in a formula that involves multiple arithmetic operations. Multiplication (*) and division (/) are performed first (first tier operations), followed by addition (+) and subtraction (-) (second tier operations). When there are multiple operations involving the same tier, the order of precedence dictates that the operations are performed from left to right. You can use parentheses, if you wish, to alter the normal order.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com