Oracle APEX 5.0 New Features Tutorial

Watch this free video tutorial and take the APEX 5.0 for a test drive. We will demonstrate the new Universal Theme, Page Designer, built-in support for Modal Windows, the new and very cool Theme Roller, Interactive Report enhancements and many other features that make APEX 5.0 so awesome. This webinar is intended for developers who have already built applications with Orace Application Express.

Presenter: Certified Oracle APEX Expert Tyson Jouglet

Language: English

Be sure to set the Youtube settings to High Definition. For best viewing, also watch in full screen mode.

  1. Experience the new login with Oracle SSO and the very helpful List of Workspaces (demonstration) (4:55)
  2. New Application Builder and Responsive Theme (demonstration) (1:33)
  3. APEX 5 Theme Roller Demonstration (5:59)
  4. (it is a mystery, what happened to Lesson 4! ) (0.00)
  5. Integrating Font Awesome (scalable vector icons) (4:17)
  6. Modal Pop-Ups in APEX 5.0 (4:03)
  7. Page Designer (8:05)
  8. Plug-Ins (6:41)
  9. Interactive Reports (8:02) (click on video below)

Date: Feb 17, 2015

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.


Interactive Reports

Introduction to APEX 5 New Features


Lesson 9 – Interactive Reports


>> Tyson:  I’m going to go ahead and click on Interactive Reports. I want you to notice here I have an interactive report on some employees and I have an interactive report – just a very long report – of IDs. This is an interactive report and this is an interactive report. So, yes. You can have many interactive reports on the same page.


There’s one really cool feature that just works out of the box. I want you to pay close attention to the headings here.




As I scroll down, notice that the headings scroll down with me. Now watch as I encounter the second interactive report. It now shifts. And now the second interactive report heading scroll is locked. As I scroll back up, it switches.


One thing to just take note of is that interactive reports now have the capabilities of pivoting on data. I’m going to click this little pivot button. I’ve pre-defined the pivot which is basically looking at jobs and their salaries across different departments. You can see how much clerks are getting paid in accounting versus research and sales. If you want to configure this, I’m going to click “Edit Pivot.”




This is what the menu looks like. Notice it’s a little modal popup, which is much nicer than before. So you can actually move this down and look at your report while you edit your pivot that you can see here. I’m pivoting on job, so you can see here the jobs listed across the top. For the different rows, I want to look at department name so you can see the department names being listed here. Then I’m saying I want to sum the salary. This is just how much we’re spending on different job types in the different departments.




You could use something like average so you can see the average salary. This is really nice because this is kind of getting into business intelligence, analytics. Interactive reports are never going to be a substitute for business intelligence, but this is a really cool feature. But one thing that I do want to point out is notice that the pivot table does not have the heading scrolling. Maybe that’s something that’s going to come later. I’m not sure. But remember the difference here is that the ID column will stay on this long report.


One other thing is that because we have interactive reports, multiple interactive reports on the same page. If I was to do something like filter – we’re going to do on employee name = Adams. We’re going to filter this report, so we’re looking at Adams. We’re going to filter this report so that we’re just looking at ID5. Apply.




If I was to leverage the clear cache or reset or clear interactive report option here, so I’m going to say RIR for reset interactive report. Notice that it’s going to reset everything on the page.


Some of you might be wondering, how do I link to a given interactive report? You may remember this functionality here. Let me copy this.




You may be used to this syntax here where you say interactive report = and you provide a column alias and a name. Let’s see what happens when I try to use this.




It tells me that report does not exist. Now you need to make sure that you specify a name of the interactive report that you would like to target. What that means is that these different interactive reports need to have an ID. How we would change that is it would be this plus static ID.




I currently am having an issue with this particular part working. But I just want to add that now we need to add the static ID here.


If you want to know what the static ID is from your interactive report, if I navigate to my EMP report –




And go down and we can find static ID. So I should be able to use EMP. The idea here is that I can use EMP_REPORT like this and it should work. The only issue here is that –




Nothing happened. Again, this is an early adopter. Actually, let me put the percent sign here. That totally broke it.




Before we go is that interactive reports have been overhauled from the ground up. So if you have any custom styling at all of your interactive reports that are using the old interactive report classes and IDs, that has all been changed. So that’s no longer going to work.


So what you’re going to have to do is you’re going to have to inspect elements here and look at the new classes and the new IDs. For the most part, it has been pretty good one-to-one mapping as far as what the new classes and IDs are. It’s pretty easy to make those changes, but it has all been changed. So any custom interactive report styling no longer is going to work in APEX 5.


>> Dave:  I got to give you one more question. Can I download an interactive report to a different type such as XLS, RTF, PDF, doc, etc.?


>> Tyson:  Yeah. If I got o “Actions” and “Download,” here you can get PDF. PDF basically is going to be produced however you have your APEX instance configured to get that PDF. It could be the ORDS version 2.0. (Oracle REST Data Services). That could be the iPublisher, it could be JasperReports. It all just depends how you have that configured.


As far as XLS, I believe there’s a plugin out there that does that for you. But there’s no XLS out of the box. It had been kind of problematic.


>> Dave:  Okay, great. Tyson, a fantastic presentation, incredible amount of knowledge that you have and you share with the group. Thank you very much.


>> Tyson:  Thank you, everyone, for attending.   


Copyright 2017

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!