A mathematical operation (such as AVG, COUNT MIN, MAX, and SUM) that summarizes the results of a query rather than listing all of the rows. For example, you could use a function such as MAX(Price) to determine the most expensive product ordered.

An alternate name for a column or table. You can use an alias for a column to make the column name clearer. For example, the alias for la_stores could be Los Angeles Stores. You can also use an alias for a table to make the table name clearer or when you create a copy of the table to use in a table self join operation.

A name used to identify an object to which you wish to link. When you create an anchor, you can link other objects to the section in your report identified by the anchor.

Connects a subquery to the master query by joining one or more query fields. Binding queries is necessary to display the results of both queries in one

An image that you can insert into a report. A bitmap has a BMP extension.

A client program that allows users to read hypertext documents on the World Wide Web and navigate between them. SQR Production Reporting Studio supports both internal and external browsers.

An icon in a toolbar, dialog box, or property page on which a user clicks to execute commands, display pop-up windows, or display menus.

An object in a report that displays statistics gathered while the report runs. For example, if you group your records by state, you could use a calculated field to print the total number of customers in each state.

A graphical representation of data such as a pie chart, a line chart, a bar chart, or an area chart. When you create a chart, you can place it in the summary section of a Tabular report, or you can create the chart as a separate report.

A named field of a specific datatype in a database table. For example, Product Code, Description, and Price could be columns in a table called PRODUCTS. Columns are also referred to as “fields.”

An expression that limits the rows of data retrieved in a query. You can combine several conditions with the logical operators AND or OR. For example, you could create conditions to limit the data retrieved to customers in California who had orders greater than $100.

The process of using a value returned by one query in the execution of another query.

A matrix or spreadsheet-like report for presenting summary numeric data. With cross-tabs, you can quickly present a summary of data based on two categories. When you create a cross-tab, you can place it in the summary section of a Tabular report, or you can create the cross-tab as a separate report.

A graphical interface for managing data objects.

The arrangement of data columns and headings that initially appears when you format your report layout.

Defines the number of report pages in each HTML file. With demand paging, you can avoid downloading an entire report in the browser. Instead, you can break a report into smaller sections for better performance.

A subset of data that meets a defined condition. When you create an exception, you can format the data in the exception so that it will stand out in a report.

A tool in SQR Production Reporting Studio that you can use to add exceptions to your report query.

A type of report that formats data and sends it to a file for use by another application.

A value that is computed based on other values in the database. For example, you could create an expression such as QUANTITY * PRICE to calculate the amount of a sale. You can use expressions for many purposes, such as: performing math calculations, concatenating two columns, and retrieving the current date and time.

A tool in SQR Production Reporting Studio used to add expressions to report queries.

Displays the JavaScript syntax for each item displayed in a report. Use this line to build equations in the Report section. For ease of use, it can be undocked and resized.

A named field of a specific datatype in a database table. Fields are also referred to as “columns.”

Graphics Interface Exchange Format. A format used for displaying bitmap images on the Web.

A feature that allows you to group database information in a report. Defining group breaks allows you to add white space to a report, avoid printing redundant data, perform conditional processing on variables that change, and print subtotals.

An expression that defines selection criteria for aggregate rows. For example, if you created an aggregate function such as MAX(Price) to determine the most expensive product ordered, you could then create a Having clause such as PRICE>1000 to limit the items printed to items over $1000.

Hypertext Markup Language. A programming language used to create World Wide Web pages, with hyperlinks and tags that explain how to format the information on the screen.

A connection made between objects in HTML documents. Clicking a hypertext link automatically displays the linked information.

A type of file that writes an external source file to an Production Reporting report. Useful for keeping commonly-used routines together in a single file that can be referenced in programs that use the routine.

A query that executes once at the beginning of a report, before the master query.

An HTML report that includes group breaks and allows you to filter information and expand and collapse detail items.

A type of analysis that extracts information from an SQR Production Reporting Studio report, chart, or cross-tab and displays the information in as an Interactive Reporting Analysis file. Interactive Reporting Analysis is a Windows-only solution.

A query operation that retrieves data from multiple database tables in one SELECT statement. Also, a common database column used to connect, or join, a pair of tables.

A value that specifies the type of connection between the database columns in tables. Join type operators include: equal, not equal, greater, less, greater or equal, less or equal, and outer join.

Joint Photographic Experts Group. A format for storing high-quality color and grayscale photographs in a bitmap form.

A type of report that creates labels to use on items such as customer mailings, file folders, and internal company routings

An SQR Production Reporting Studio screen display where you can insert and position everything that will print in your report.

A program that loads sample data into a database. The loadall program is included with Production Reporting.

A function in the Production Reporting language and SQR Production Reporting Studio that improves the speed of query execution by performing a often-used pattern of query processing with a single access to the database.

A type of report that shows hierarchical information. The information is normally retrieved from tables that have a one-to-many, or master/details relationship.

A query that you define for a detail report in a Master/Detail report that returns zero to many values and can be nested to many levels.

Open Database Connectivity. A standard for accessing different database systems. SQR Production Reporting Studio uses ODBC Drivers during the Query Building process to provide database independence when building an SQR Production Reporting Studio report.

A type of join that includes all of the rows from one of the tables joined, regardless of whether there were matches in the other table.

A set of instructions that specify which data to retrieve from a database for use in a report.

A report “wizard” containing several pages that collect information and step you through the process of building a query.

A type of condition that allows you to enter different values and generate a new result set each time you run a report. You can also create a default value if a user fails to enter a value at run-time.

An SQR Production Reporting Studio screen display where you can view your report. Typically, the report displays in an HTML format using an internal browser. If you do not want to use an internal browser or if your system does not support it, the report displays in an SPF format.

An operation that correlates the data in a single table.

One of a series of master queries that execute in a sequential order in the same report.

A query that you define for a detail report in a Master/Detail report that can only return one row and cannot have any detail queries of its own.

An SQR Production Reporting Studio screen display where you can view or edit the generated Oracle's Hyperion® SQR® Production Reporting code used to create your report.

The file that SQR Production Reporting Studio creates when it executes an SQR file. SPF files contain a representation of the actual formatted report output, including fonts, spacing, headers, and footers.

A file that contains the actual script that SQR executes to run a report

A tool that allows you to write a new Production Reporting program or edit an existing Production Reporting program. The Production Reporting Editor is included as part of SQR Production Reporting Studio

A specialized programming language for data access, data manipulation, and reporting.

A saved SQR Production Reporting Studio layout. An SRM file is a binary file with a proprietary format.

A saved SQR Production Reporting Studio layout template.

A query that is a component of another query.

Calculated fields generated by the default layout in the Group Summary section of a report.

A hidden or private table that generally contains information about the database.

The basic unit of data storage in a database. Database tables hold all of the user-accessible data. Table data is stored in rows and columns.

A type of report that includes database information in columns on the page.

A document that defines the look and feel of a report, while remaining separate from the report. A template can contain objects inserted into the report layout, report properties, and formatting styles. In SQR Production Reporting Studio, templates are also referred to as Layout Templates.

An SQR Production Reporting Studio display where you can define the settings to be used in an SQR Production Reporting Studio layout template.

Uniform Resource Locator. The current addressing scheme for resources on the Internet or an Intranet.

A value that can be modified when you run a report. String variables are useful for concatenating two or more database columns. Numeric variables can calculate values based on other values in the database. Encode variables are string variables that contain nondisplay and other special characters.

A tool in Oracle's Hyperion® SQR® Production Reporting Studio that you can use to add variables to your report.

A custom-tailored presentation of the data in one or more database tables. Views do not actually contain or store data; rather, they derive their data from the tables on which they are based, referred to as the base tables of the views.

A condition (or expression) used to limit the number rows that the query has to search. Where clauses usually consist of an expression or column, an operator, and one or more values.