Sunday, May 20, 2012

Oracle Apex: Resizing an image (BLOB) in interactive report

If you are putting an image in one of your columns in an interactive/classic report, you may want to reduce them all to same size or make the oversized images appear smaller.

Simply add this CSS to your page HTML header section:

<style type="text/css">

.apexir_WORKSHEET_DATA  td[headers="IMG_COL"] img
{

  width: 100px;
  height: 100px; 
}

</style>

Replace IMG_COL with the name of the BLOB column holding the image.

Note: This may not work with Internet Explorer.

7 comments:

  1. Thanks, this post was very helpful to me!!

    ReplyDelete
  2. In Apex 5.2 this is not working. Please sugggest.

    ReplyDelete
  3. Yes this is not working in APEX 5.0 and higher versions!
    Can any one help me

    ReplyDelete
  4. And sure it does not work in apex 19.2

    ReplyDelete
    Replies
    1. It’s a post from 2012 (4.2 days), obviously not tested in latest APEX versions.

      Delete
  5. put this in the CSS-Inline field in page parameters and it will work...
    img {
    width: 100px;
    height: 100px;
    }
    courtesy of Rex Araya https://apex.rexaraya.com/resize-image-in-apex-interactive-report/

    ReplyDelete
  6. That worked great in 5.1 version

    ReplyDelete