18.6.10.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. To learn more, see field-level Help.
   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.
   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.

6. Navigation - If needed, expand the region. Enable or disable the following flags:
   1. Use Breadcrumb - Enable to create a breadcrumb entry for this page. By default, the page name is used as breadcrumb entry name.
   2. Use Navigation - Enable to create a navigation menu entry for this page. By default, the page name is used as navigation menu name.

   If either flag is enabled, additional attributes appear. To learn more about an attribute, see field-level Help.

7. Click Create Page.
8. Click Save and Run Page to view the chart.