APEX

1. 1.   Create a new page by clicking the Create Page button and select new blank page then add Report region option in the first wizard screen, followed by the Interactive Grid option on the next screen.

1. 2.    Set Page Number to 100, Page Name to Column Groups, Page Mode toNormal, Breadcrumb to Breadcrumb, Parent Entry to No Parent Entry,Entry Name to Column Groups, and click Next.

1. 3.  Set Navigation Preference to Do not associate this page with a navigation menu entry, because this page is not associated with our sales application. Click Next.

1. 4.     On the Report Source screen, set Editing Enabled to No, set Source Type toSQL Query, and enter the following SQL Statement in Enter a SQL SELECT Statement text area. Read this post to add the table used in the following query.

SELECT empno,ename,job,mgr,hiredate,sal,comm,deptno,onleave,notes,
flex4 as tags

FROM EBA_DEMO_IG_EMP

1. 5.      Click the Create button to finish the page creation process.

1. 6.  In the Page Designer, under the Column Groups region (in the Rendering tree), right-click the Attributes folder, and select Create Column Group from the context menu. In the Properties pane, set the Heading attribute for this new group to Identity.

1. 7.   Repeat step 6  to create two more groups. Enter Compensation and Notes for their headings.

1. 8.   Under the Columns Group region, expand the Columns folder. Click theEMPNO column and set its Type to Hidden.

1. 9.      Set the appropriate column headings, as shown in Figure 5-5.

1. 10. Use the following table to associate each column with a group defined in steps 6 & 7. To establish this association, click any column (ENAME, for example), scroll down to the Layout section, and set the Group property as follows:

1. 11. Save your work and run the page. Column group headings can be used to reorder columns just like column headings. Play around with column reordering (using drag and drop) to see how the group headings are split and joined.

thanks in advance,