17.3.8.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 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. 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.
7. Click Create Page.
8. Click Save and Run Page to view the chart.