Freeze the first column and headers of an Oracle APEX Classic Report
Switch branches/tags
Nothing to show
Clone or download
Latest commit 36291f7 Sep 11, 2017
Permalink
Failed to load latest commit information.
plsql First release Sep 10, 2017
www First release Sep 10, 2017
.gitignore First release Sep 10, 2017
LICENSE First release Sep 10, 2017
README.md because badges Sep 11, 2017
apexplugin.json Small description corrections Sep 10, 2017
dynamic_action_plugin_jmr_freeze-header-column.sql First release Sep 10, 2017
preview.gif First release Sep 10, 2017

README.md

APEX Freeze Column & Headers

APEX Community APEX Plugin APEX Built with Love

An Oracle APEX Dynamic Action plugin for freezing the (first) column and headers of a Classic Report (using the Universal Theme)

Demo

Run Demo

Preview

Alt text

How to use?

  1. Create an "After Refresh" Dynamic Action on the Classic Report you want to "freeze".
  2. For the True Action select "Insum Freeze Headers & Column"
  3. Make sure "Fire on Initialization" is Yes.
  4. Don't specify an affected element; the plugin uses this.triggeringElement

FAQ

  • Can I freeze multiple reports on the same page? YES!

  • How can I change the height of the report?

Currently the report CSS defaults to 500px. It's very easy to override with a CSS line like this:

#STATIC_ID table.t-Report-report tbody {
  height: 750px;
}

Known Issues

If you resize the browser by making it larger, the header may fit, but the body may extend. A possible fix is to re-run the sizes code on head/body after resize. However, the workaround is to simply reload the page.

Disclaimer

This plugin may have defects. Test, validate and use at your own risk and without any warranties.

Issues/Questions

Pending

  • Allow configuration to Freeze more than the first column.

Credits

Thanks to Insum Solutions for sponsoring this project.

Portions of the code are based on https://jsfiddle.net/RMarsh/bzuasLcz/3/