This interactive grid was created using the Create Page Wizard. The SQL used to create this report displays in the show/hide region at the bottom of the page. Interactive grids feature built-in search capability in that your search term is used to search across the row. They also allow for the addition of new rows (click the Add Row button), deletion of existing rows (select rows, click the top row actions icon, select Delete Rows), and editing of cell data in any/all rows (double-click in any cell, change content, click the Save button). You can sort and filter columns by clicking on column headings, click the Actions drop down menu to control the columns to display on the report and the order in which they are displayed. You can also save custom reports, chart data, and perform many other actions.
select ROWID, ID, PROJECT, TASK_NAME, START_DATE, END_DATE, STATUS, ASSIGNED_TO, COST, BUDGET, budget - cost available_budget from EBA_DEMO_IR_PROJECTS