Oracle Application Express - add mutliple chart on the same page
To add multiple chart and tabular table to the same apex page is an common requirement for apex applications development. and it is easy to implment this feature using apex 's concept of 'Region'.
For Apex, Each chart or table is placed inside a 'region', so multiple 'region' could be arranged on different section of the same page to make up the multiple chart on the same page effect.
The above Apex page is made of two region which data could be draw from totally different data tables
Step to add multiple chart or table
First just use Apex wizard to add one page to the apex application, the page will contain one chart or table data after the configuration.
Then go to 'edit page' , find the section 'Regions' , we will have a definition like the following :
Usually the 'Region' section will contain only one row that define the chart or table for the page after finishing the wizard process.
To adding another chart or table to the page, just click the icon on the upper righ of the region section with the '+' symbol. Then we will come to the normal screen to define normal apex chart or report.
After the configuration. This new 'Region' which contain the new chart will be display under the previous defined region on the same page.
Place a chart on specific page position
We could also arrange the position of these charts by clicking the icon with a small pen on the upper right of the 'Region section', The chart posistion coud be arranged by entering different sequence value and column value:
The 'Sequance' value define whether the regions is arranged side by side or top and down, same value means side by side while different 'Sequance' value means top and down, the smaller value of the sequence of the region will make it on the top of the page.
The 'column' value define whether the region is on the left of the page(first column ) or on the right of the page (sencond column), of course, it is also possble to have multiple column side by side.
The position of each chart's position could be defined using these 'Sequence' and 'Column'!
Recommended books:
Author: Rick Greenwald
Publisher: Wrox (2008)
Binding: Paperback, 384 pages