17.3.7.1 Creating a Report Using a REST Enabled SQL Reference

Create a report on a remote database using a REST Enabled SQL reference.

The following example demonstrates how to create an interactive report based on a table using a REST Enabled SQL reference. The procedures for creating other report types is similar.

Tip:

Before creating a report using a using a REST Enabled SQL reference, you must complete the tasks described in Before You Begin: REST Enabled SQL Service Requirements and create the reference as described in Creating a REST Enabled SQL Service Reference.

To create an interactive report using a REST Enabled SQL reference:

1. Create a REST Enabled SQL reference.
2. Run the Create Page Wizard:
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Create Page.
      Create a Page appears and features three tabs: Component, Feature, and Legacy Pages.
3. Under Component, select Interactive Report.
4. Under Page Definition:
   1. Page Number - The page number is an integer value that identifies a page within an application.
   2. Name - Specify a text name for this page.

      Tip:

      This text is also used for page Title. After page creation, you can modify the Title in Page Designer.
   3. Page Mode - Identify the page mode: Normal or Modal.

      See field-level Help for more details.

   4. Include Form Page - Enable this flag to create a form page along with the report page.

      Form pages are always created as Modal Dialog pages. Enabling this flag displays additional attributes. To learn more about an attribute, see field-level Help.

5. Under Data Source:
   1. Data Source - Select REST Enabled SQL Service.
   2. REST Enabled SQL Service - Select a previously defined reference.
   3. Source Type - Specify the source of the new page. The UI changes based on your selection. Options include:

      • Table:

        • Table /View Owner - Select the owner of the table on which you are building the page.

        • Table/View Name - Select the table or view on which the page will be based.

      • SQL Query:

        • Enter a SQL SELECT statement - Enter the SQL query. To see an example, expand the SQL Query Example region.

   4. Select Columns - Select one or more columns to be included in the region. Selected columns will display in the report.
6. Navigation - Expand the region and enable or disable navigation. If either flag is enabled, additional attributes appear. To learn more about an attribute, see field-level Help.
   1. Breadcrumb - Enable to create a breadcrumb entry for this page. By default, the page name is used as breadcrumb entry name.
   2. Navigation - Enable to create a navigation menu entry for this page. By default, the page name is used as breadcrumb entry name.
7. Click Create Page.
8. Click Save and Run Page to view the chart.