In Oracle APEX, a column group is a way to organize and manage columns in a report region. It allows you to group related columns together and apply certain settings to the entire group. Column groups provide a convenient way to enhance the readability and organization of your report layouts.
Here’s how you can create a column group in Oracle APEX:
Navigate to your APEX application:
Log in to Oracle APEX, select your application, and go to the page where you have a report region.
Edit the Report:
Navigate to the page containing the report region, and then go to the “App Builder” section. Locate the page that contains your report, and click on the report region to edit it.
In the report attributes, find the “Columns” section. Here, you can see a list of all the columns included in your report.
Create a Column Group:
Select the columns you want to group together by holding down the “Ctrl” key (or “Command” key on Mac) and clicking on the columns.
Right-click on one of the selected columns and choose “Group Columns.”
Define the Column Group:
A pop-up window will appear where you can provide a name for your column group.
You can also specify certain settings for the entire group, such as display options and column heading.
Save and Run:
Click “OK” or “Apply Changes” to save the column group settings.
Run the report to see the changes.
Column groups help you organize the display of columns in your report. For example, you might have a group for “Basic Information” that includes columns like name and address, and another group for “Financial Information” that includes columns like revenue and expenses.
Keep in mind that the exact steps and options may vary slightly depending on the version of Oracle APEX you are using. It’s always a good idea to refer to the documentation or help resources specific to your APEX version for the most accurate and up-to-date information.