10.3.5 Adding a Chart on a New Page Using a Local Database

Run the Create Page Wizard to add a new chart page using a a local database.

To add a chart on a new page using a a local database:

1. On the Workspace home page, click the App Builder icon.
2. Select an application.
3. Click Create Page.
   The Create Page Wizard appears.
4. For Create a Page:
   1. Page Type - Select Component and then Chart.

      Tip:

      Component pages provides page-level functionality and can be added multiple times within a given application such as reports, forms, charts, or calendars. Feature pages provide application-level functionality and can only be added once per application.

   2. Select select a chart type.
5. For Page and Region Attributes:
   1. Page Number - Enter a page in which the chart object is to appear.
   2. Page Name - Enter a page name.
   3. Page Mode - Select a page mode.

      • Normal - The page displays as a normal Application Express application page.

      • Modal Dialog - The page displays as a modal dialog. A modal dialog is an overlay window which remains active and focused until the end user closes it. The underlying page is grayed out which prevents the end user from interacting with the rest of the page until the dialog closes.

   4. Breadcrumb - Select whether you want to use a breadcrumb navigation control on your page.
   5. Click Next.
6. For Navigation Preference, specify the type of navigation to include on this page and click Next. The navigation options (for example, navigation menu or tabs) depends upon the current application theme.
7. The steps that follow depend upon the Source Type: Table or SQL Query.

   • If the Source Type is Table:

     1. Location - Select Local Database.

     2. Source Type - Select Table.

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

     4. Table/View Name - Select the table or view on which the chart is based.

     5. Page Items to Submit - Enter a comma separated list of page items on the current page to be set into session state when the chart data gets read with a separate request.

     6. Maximum Rows - Enter the maximum number of rows you want to use to display the chart.

     7. Click Next.

   • If the Source Type is SQL Query:

     1. Location - Select Local Database.

     2. Source Type - Select SQL Query.

     3. SQL Query - Enter the SQL SELECT statement to be used for the chart. The SQL SELECT statement must include at least two columns.

     4. Page Items to Submit - Enter a comma separated list of page items on the current page to be set into session state when the chart data gets read with a separate request.

     5. Maximum Rows - Enter the maximum number of rows you want to use to display the chart.

     6. Click Next.

8. For Column Mapping:
   1. Select the columns to be mapped to the chart. The options that display vary depending upon the chart type selected. To learn more about an attribute, click the field-level Help.
   2. Click Next.
9. Click Create.