Exporting an Interactive Report in one click is possible, you don’t have to use the right menu witch can save your user 3 clicks!
To accomplish this you have make a branch to the page containing an Interactive Report and play around with your Page Request:
- HTMLD (ApEx 4.0 Only)
Although this sounds actually very nice, it becomes less nice when I try to disable the export for an Interactive Report.
Even when I disable every option for the Interactive Report, it still will allow me to download all the data when playing around with the page request.
Maybe not a critical issue but definitely something to take in account when you use a lot of Interactive Reports.
When creating a new workspace you might have noticed that there will be some extra tables on your schema.
All these table start with the name APEX$_ and are used for the websheets feature of the new version of ApEx.
If you don’t use websheets (at start) and you don’t want these extra tables present on your schema then you can prevent the creation of these tables by following the next steps:
- Login into the internal workspace
- Go to Manage Instance -> Feature Configuration
- Set “Create Websheet objects in new workspaces” to No
Please keep in mind that the above action will still allow developers to make websheets. If these objects do not exist then the developer will see a warning message when he/she tries to create a websheet. You then will able to create these objects again:
If you have the Websheet Objects on your schema and you wish to remove them then go to “
Home -> Administration > Manage Service -> Websheet Database Objects” and there you can safely remove these objects.