10g (9.0.4)
Part Number B10612-01
 Home |
 Contents |
 Index |
| Oracle Reports Tutorial 10g (9.0.4) Part Number B10612-01 |
|
A relational model that defines what data should be fetched from the data source(s), what values should be computed, and how data should be ordered in a report. Reports Builder objects that define the data model are queries, groups, columns, parameters, and links.
One of the views of the Report Editor that displays a structural representation of the data in a report. The objects do not appear in the report output, but the structure determines the layout style, and the data objects provide the values that appear in the layout objects.
A source for data returned by a query, including database objects such as tables, views, synonyms, snapshots, and queries stored as views. OracleAS Reports Services allows you to access any data source.
The new pluggable data source (PDS) architecture replaces Oracle Open Client Adapter (OCA), and the Open Database Connectivity (ODBC) drivers are no longer supported in Oracle Reports 10g. However, Java Database Connectivity (JDBC) is one of the pluggable data sources available that can utilize the JDBC-ODBC bridge, allowing access to other data sources.
When defining a master/detail report, the detail query retrieves all related records for each record retrieved by the master, or parent, query.
A partial screen or window that prompts you to enter information necessary to complete an operation.
An interface element state that means a menu item, button, and so on, cannot be used in the current context (i.e., it does not respond to keyboard or mouse input).
See view.
An interface element state that means that a menu item, button, and so on, can be used in the current context (that is, it responds to keyboard or cursor/mouse input).
A value or column in one table that refers to a primary key in another table.
A setting that defines the appearance of the value of a field. For example, a format mask is used to specify the display of currency amounts and dates.
A PL/SQL function that allows you to dynamically change the formatting attributes of an object.
A user-created column that gets its data from a PL/SQL function or expression, a SQL statement, or a combination of these.
A layout object used to enclose other layout objects and control the formatting, frequency, and positioning of several objects simultaneously.
Acronym for Hypertext Markup Language. A tag-based ASCII language used to specify the content and links to other documents on Web servers on the Internet. End users with Web browsers view HTML documents and follow links to display other documents.
A reference (link) from some point in one document to (some point in) another document or another place in the same document. A Web browser usually displays a hyperlink in some distinguishing way (in a different color, font or style). When users activate hyperlinks (by clicking on them with a mouse) the browser displays the target of the link.
A graphic representation of a window or tool.
A bitmapped object that can be stored and loaded into an application. The client cannot modify an imported image.
An internal TCP/IP network, access to which is restricted (via a firewall) to individuals inside the company or organization. An intranet provides similar services within an organization to those provided by the Internet, but is not necessarily connected to the Internet. A common example of an intranet is when a company sets up one or more Web servers on an internal network for distribution of information or applications within the company.
A computer language that supports programming for the Internet in the form of platform-independent "applets".
JavaServer Page (JSP) technology is an extension to the Java Servlet technology from Sun Microsystems that provides a simple programming vehicle for displaying dynamic content on a Web page. JSP is a server-side technology. A JSP is an HTML page with embedded Java source code that is executed in the Web server or application server. The HTML provides the page layout that is returned to the Web browser, and the Java provides the business logic.
See Paper Layout view.
An optional report region that appears at the top and bottom of each logical page in a report section (Header, Main, or Trailer). The margin may include any layout object, but typically contains boilerplate and fields (for page numbers, page totals, grand totals, and current date and time).
A hierarchical browsing and editing interface that enables you to locate and manipulate application objects quickly and easily. Features include:
A strategic platform for network application deployment. By moving application logic to application servers and deploying network clients, organizations can realize substantial savings through reduced complexity, better manageability, and simplified development and deployment. OracleAS provides the only business-critical platform that offers easy database Web publishing and complete legacy integration while transitioning from traditional client-server to network application architectures.
Combines leading Oracle application development and business intelligence tools into a single, integrated product. Built on Internet standards such as Java and XML, the suite provides a complete and highly productive development environment for building applications for Oracle Application Server and the Oracle database.
An alternate name for the top directory in the Oracle directory hierarchy on some directory-based operating systems. An environment variable that indicates the root directory of Oracle products.
You can refer to the directory specified by ORACLE_HOME in syntax:
On UNIX: $ORACLE_HOME
On Windows: %ORACLE_HOME%
An HTML-based development tool for building scalable, secure, extensible HTML applications and Web sites. OracleAS Reports Services uses OracleAS Portal to control end user access to reports published on the Web by storing information about report requests, the secured server, and any OracleAS Reports Services printer used to print report output.
See Reports Services.
One of the views of the Report Editor that displays output for paper reports and allows you to make many commonly required, simple modifications to the layout, such as spacing, formatting fields, color, and editing text, without having to open the Paper Layout view.
One of the views of the Report Editor that displays the layout objects in a paper report and allows you to make many modifications to any layout object. All layout objects have properties that you can modify using the Property Inspector. The hierarchy of the layout objects is determined by the Data Model.
Displays the layout of the Parameter Form that, at runtime, allows user input of parameter values in the Runtime Parameter Form.
Acronym for Portable Document Format. A file format (native for Adobe Acrobat) for representing documents in a manner that is independent of the original application software, hardware, and operating system used to create the documents. A PDF file can describe documents containing any combination of text, graphics, and images in a device-independent and resolution independent format.
Oracle's proprietary extension to the SQL language. Adds procedural and other constructs to SQL that make it suitable for writing applications.
A window that enables you to view, locate, and set the properties of the currently selected object(s) in the Object Navigator, Report Editor, and Template Editor. Every Reports Builder object (query, group, frame, parameter, etc.) has associated properties that can be viewed using the Property Inspector. The Property Inspector features:
To get help on any property, click the property in the Property Inspector and press F1.
A SQL SELECT statement that specifies the data you wish to retrieve from one or more tables or views of a database.
A file that contains a single report definition in binary format. .RDF files are used to both run and edit reports.
One row fetched by a SQL SELECT statement.
A layout object used to display rows of data that are fetched for a group.
The Reports Builder window that provides different views to help you handle the data objects and layout objects for Web and paper reports. The views are:
An Oracle Reports executable that starts Reports Builder to enable report developers to create and maintain report definitions.
An Oracle Reports executable that runs a report using the OracleAS Reports Services in-process server.
The runtime environment for Reports Developer applications. OracleAS Reports Services executes, distributes, and publishes your reports for enterprise wide reporting. Using OracleAS Reports Services to deploy your reports results in gains of flexibility, time savings, and processing capacity.
An Oracle Reports executable that translates and delivers information between HTTP and the Reports Server, enabling you to run a report dynamically from your Web browser.
One set of field values in a table; for example, the fields representing one employee in the example table EMP.
A screen or window appearing optionally at runtime in which a user can modify print options and parameters prior to report execution.
A collection of related database objects, usually grouped by database user ID. Schema objects include tables, views, sequences, stored program units, synonyms, indexes, clusters, and database links.
A SQL statement that specifies which rows and columns to fetch from one or more tables or views.
A standard interface for storing and retrieving information in a relational database. SQL is an acronym for Structured Query Language.
A file that contains a query stored in text (e.g., ASCII or EBCDIC) format.
A file containing SQL statements that you can run to perform database administration quickly and easily. Several SQL scripts are shipped with Oracle products.
A SQL instruction to Oracle. A SELECT statement is one type of SQL statement.
HTML extensions that provide powerful formatting flexibility in HTML documents. To view an HTML document that takes advantage of style sheets, display it in a browser that supports style sheets.
A named collection of related information, stored in a relational database or server, in a two-dimensional grid that is made up of rows and columns.
A default layout displaying labels at the top of the page and rows of data underneath the labels.
A skeleton definition containing common style and standards, and may include graphics. A template provides a standard format to enable quick and easy development of professional standard look-and-feel reports.
A work area in which you can define objects and formatting properties for your templates. It is similar to the Paper Layout view of the Report Editor. You can create, delete, and modify objects (e.g., page numbers, text, and graphics) in the margin area. You cannot create and delete objects in the body area, but you can modify the properties of body objects in the Property Inspector.
An iconic button used to create and manipulate objects in an application.
A collection of tools represented by iconic buttons in the user interface that allow a report developer to perform tasks, such as drawing a rectangle in the Paper Layout view or creating a query in the Data Model view.
A collection of iconic buttons that perform product commands. Usually aligned horizontally along the top, or vertically down the side of a window.
A compact string representation of the location for a resource that is available through the Internet. It is also the text string format clients use to encode requests to OracleAS.
A program that end users utilize to read HTML documents and programs stored on a computer (serviced by a Web server).
A server process (HTTP daemon) running at a Web site which sends out Web pages in response to HTTP requests from remote Web browsers.
One of the views of the Report Editor that displays the HTML / JSP source for a report. You can use this view to add dynamic content to a Web page using the Report Block Wizard and the Graph Wizard. Experienced Java developers can edit the Web source directly in this view.
A step-by-step interface for commonly performed tasks. The wizards in Reports Builder are:
Acronym for Extensible Markup Language. A metalanguage using SGML to define and structure data. Reports Builder supports XML output to enable Web publishing as well as electronic data exchange with third-party applications. You can also use XML to build report definitions that can be merged with other report definitions at runtime or run separately.
|
 Copyright © 2002, 2003 Oracle Corporation. All Rights Reserved. |
|
