Creating a query-based report output

You can run a query-based report definition and save its output in a single step.

1.         Click the Reports tab.

The Report Definitions page appears.

2.         Click Interactive Reports.

The Interactive Reports page appears.

A.        Click the row menu () for the report definition, and then click Create Output.

The Select Configuration page appears.

3.         From the configuration drop-down list, select a configuration.

The report runs against source data for the selected data configuration. When you save the report output, the application verifies that the selected data configuration has a Drug type variable with a subtype of Generic, Trade, or Ingredient.

4.         Click Next.

The Run Query page appears.

5.         Fill in the fields, and click Next.

The Create Output page appears.

6.         Fill in the fields:

• Name for Output—Name for the saved output. The name does not need to be unique, although Oracle recommends that you provide a unique and meaningful name.

• Output Description—Description of the saved output that differentiates the report output from entries on the Report Outputs page.

• Output Category—Type of report output: Ad Hoc or Standard. The application uses the category for organizing reports and the category is not related to report availability. You can include a column showing report categories on the Report Outputs pages.

7.         Select an option for assigning the report output to a project:

1. Add to existing project—Assign the report output to an existing project by selecting from a list of projects associated with objects that you created or that are published to you.
2. Add to a new project named—Create a new project and assign the report output to it.

8.         Click Save.

The application submits the report output to your background processing job queue, and the Background Processing indicator appears next to the Preferences link.