More APEX sessions at Oracle OpenWorld 2008

Written by Paulo Vale on Monday, July 21, 2008

According to Oracle OpenWorld Blog, the top 25 voted sessions at Oracle Mix will be presented at Oracle OpenWorld 2008. Among the 25 winners there is a good representation of APEX, meaning that APEX community is very active. The winners, APEX related are:

Rank: 1 (113 votes)
Security: Writing Custom Authentication Schemes for Oracle Application Express (Oracle APEX). 
Submitted by: Raj Mattamal

Rank: 5 (90 votes)
How to Hack an Oracle Application Express Application. 
Submitted by: Anton Nielsen

Rank: 6 (87 votes)
Successfully Developing and Integrating Applications in Oracle APEX Within Oracle E-Business Suite.
Submitted by: Haseeb M

Rank: 12 (75 votes)
(Re)Developing a Logistic Application in Oracle APEX in the Real World. 
Submitted by: Roel Hartman

Rank: 16 (68 votes)
Oracle APEX Team Development: Best Practices, Collaboration, and Application Deployment. 
Submitted by: Priya Lapham

Rank: 18 (66 votes)
Rapid Development and Validation of Oracle APEX Applications at an FDA-Regulated Medical Device Company. 
Submitted by: Deb Groskreutz

Rank: 21 (61 votes)
Using Oracle APEX to Analyze Your PL/SQL Source Code.
Submitted by: Flavio Casetta

What I miss the most in interactive reports

Written by Paulo Vale on Monday, July 21, 2008

I'm obliged to say that the Interactive Report Regions is one of the best features in APEX. The possibilities are huge. It's like passing the power to the end users.

A few days ago, I've posted about IRR having an upgrade in the next APEX release. The feature is being called as websheets. The possibility of having a tabular form with inline edit combined with the actual IRR features it's a "just can't wait" functionality.

Still, Interactive Reports are not perfect :) There are some functionalities I miss from the classic reports. I know that I can still use the classic reports, and I do use them many times, but having the possibility I tend to use the IRR as much as I can.

One of the functionalities I miss the most from classic reports is the possibility of being based on a function returning a query. This adds the possibility of a report being dynamically based on different tables or views and having dynamic where clauses. One of the situations where this is very useful is if you want to build a report wizard system in your application.

Also important, would be the possibility to have control over the report template and CSS, something similar to what we have in APEX classic reports.