Creating a Flash Chart

About Flash Charts

Flash chart support in Oracle Application Express is based on the Anychart Flash Chart Component. Anychart is a flexible Macromedia Flash-based solution that enables developers to create animated, compact, interactive flash charts. Flash charts are rendered by a browser and require Flash player 9 or later.

http://www.anychart.com

Adding a Flash Chart to an Existing Page

To add a flash chart to an existing page:

1. Navigate to the Page Definition. See "Accessing the Page Definition".

2. On the Page Definition, create a new region:

   • Tree view- Under Page Rendering, right-click Regions and select Create.

   • Component view - Under Region, click the Create icon.

   The Create Region Wizard appears.

3. Select Chart and click Next.

4. Select Flash Chart and click Next.

5. For Chart Type:

   1. Select a chart style (for example, Column) and click Next.

   2. Select a specific chart type (for example, 3D Column) and click Next.

6. For Display Attributes

   1. Specify the following:

      • Title

      • Region Template

      • Parent Region

      • Display Point

      • Sequence

      • Column

      To learn more, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

   2. Click Next.

7. For Display Attributes, select the appropriate attributes and click Next.

   To learn more about a specific attribute, click the item label.

8. For Source:

   1. Specify a query by either:

      • Entering a SQL query in the field provided. See "About Creating SQL Queries for Charts".

      • Clicking the Build Query button. When the Build Chart Query Wizard appears, follow the on-screen instructions.

   2. Specify relevant chart attributes. To learn more, click the item label.

9. Click Create Region.

Adding a Flash Chart to a New Page

To create a flash chart on a new page:

1. On the Workspace home page, click the Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Chart and click Next.

5. Select Flash Chart and click Next.

6. For Chart Type:

   1. Select a chart style (for example, Column) and click Next.

   2. Select a specific chart type (for example, 3D Column) and click Next.

7. For Display Attributes

   1. Specify the following:

      • Page Number

      • Page Name

      • Region Template

      • Region Name

      • Breadcrumb

      To learn more, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

   2. Click Next.

8. Specify whether to include tabs and click Next.

9. For Display Attributes, select the appropriate attributes and click Next.

   To learn more about a specific attribute, click the item label.

10. For Query:

    1. Specify a query by either:

       • Entering a SQL query in the field provided. See "About Creating SQL Queries for Charts".

       • Clicking the Build Query button. When the Build Chart Query Wizard appears, follow the on-screen instructions.

    2. Specify the remaining attributes. To learn more, click the item label.

    3. Click Next.

11. Click Finish.

Upgrading all Flash 3 Charts to Flash 5

To upgrade all Flash 3 charts in an application to Flash 5:

1. On the Workspace home page, click the Application Builder icon.

   The Application Builder home page appears.

2. Select an application.

   The Application home page appears.

3. Click Utilities and then click Upgrade Application.

   The Upgrade Application Summary report appears.

4. For Upgrade Flash Charts to Flash Chart 5, click the number of candidate objects.

5. Select the objects to upgrade and click Upgrade.

Upgrading a Flash 3 Chart to Flash 5

To upgrade a Flash 3 charts Flash 5:

1. Navigate to the Page Definition. See "Accessing the Page Definition".

2. Access the Chart Attributes page:

   • Tree view- Under Page Rendering, double-click the region name.

   • Component view - Under Region, select the region name.

     The Region Definition appears.

3. From the Tasks list, click Upgrade to New Flash Chart.

4. Click Upgrade.