Creating a Classic report in Oracle Apex involves several steps. Here's an overview of the process:
Create a new page: Start by creating a new page in your application where you want to display the report. You can do this by clicking on the "Create Page" button in the Pages section of the application builder.
Add a Classic report region: Once you have created the new page, you need to add a Classic report region to it. To do this, click on the "Create Region" button in the layout section of the page builder and select "Classic Report" as the region type.
Define the SQL query: After adding the Classic report region, you need to define the SQL query that will retrieve the data for the report. You can do this by clicking on the "SQL Query" button in the region attributes section of the page builder.
Configure the report columns: Once you have defined the SQL query, you need to configure the report columns. This involves specifying the column headings, widths, and formatting. You can do this by clicking on the "Columns" button in the region attributes section of the page builder.
Customize the report layout: You can customize the layout of the Classic report by using the various options available in the region attributes section of the page builder. For example, you can specify the number of rows to display per page, add pagination controls, and enable sorting and filtering.
Preview and test the report: Once you have configured the report, you can preview it by clicking on the "Run" button in the page builder. You can also test the report by entering different values into any parameters or filters that you have defined.
Save and publish the report: Finally, once you are satisfied with the report, you can save and publish it by clicking on the "Save" button in the page builder. This will make the report available to users of your application.