A Classic Report in Oracle APEX is the simplest way to display data from a database. Unlike the Interactive Grid, it is "Read-Only" by default and is perfect for simple lists, cards, or search results where you don't need complex user filtering.
Here is your step-by-step guide to creating one.
Step 1: Start the Create Page Wizard
Open your application in the App Builder.
Click the Create Page button.
Select Component and then click on Report.
From the list of report types, select Classic Report.
Step 2: Set Page and Region Identity
Page Number: APEX will suggest one (e.g., Page 10).
Name: Give it a title, like
Product List.Breadcrumb: (Optional) Select if you want navigation links at the top.
Click Next.
Step 3: Define the Data Source
This is where you tell APEX which data to show.
Source Type: Select Table / View (or SQL Query if you want to write your own code).
Table Name: Click the search icon and select a table (e.g.,
DEMO_PRODUCT_INFO).Click Create Page.
Step 4: Customize in Page Designer
Once the page is created, you will be taken to the Page Designer. Here you can fine-tune the report:
Click the Report Region in the left-hand tree.
On the right-hand Attributes tab, you can change the Template (e.g., change from "Standard" to "Cards" or "Comments").
In the Columns node (left side), you can click individual columns to hide them, change their headings, or format them (e.g., making a price column show as
$100.00).
Step 5: Run and View the Report
Click the Play (Run Page) button in the top right corner. You will see your data neatly organized in a standard table.
Comments
Post a Comment