Transcript

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.

 

[pause]

 

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.”

 

[pause]

 

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.

 

[pause]

 

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.

 

[pause]

 

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.

 

[pause]

 

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.

 

[pause]

 

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.

 

[pause]

 

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 –

 

[pause]

 

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 –

 

[pause]

 

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

 

[pause]

 

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 SkillBuilders.com 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!

 

×