How can I get an image or link to show up in an Oracle APEX Interactive Report?

html image hyperlink oracle-apex
Spags picture Spags · Sep 6, 2011 · Viewed 11.9k times · Source

I have recently started attempting to develop a web application in Oracle APEX and have come across some issues that have stumped me. Namely having HTML strings stored in the database be parsed as HTML and not simply displayed as text...

In my database (which I imported from an Excel spreadsheet, which I had exported from my department's Access database) I have two columns: Icon and Link. Icon contains an HTML string, <img src="images/icon.png">, which denotes what the status of the document in that row is. Link contains another HTML string, <a href="link.html">LINK</a>, which is unique for each row and links to an exterior HTML page with further information. This database had previously been being exported weekly and converted to HTML manually and put online for upper management to view the status of the documents my team is working on.

When I heard about APEX I was excited because it looked like it would be a good replacement for our Access database and static HTML reports and forms. I still think that it will be but there are some quirks that I need help figuring out, namely how to have my HTML strings be parsed and displayed instead of just outputed as text.

Any thoughts? I am relevtively new to APEX but I know SQL. Please be as clear and detailed as you can, Thanks!

Answer

Tony Andrews picture Tony Andrews · Sep 7, 2011

Make sure the Display Type of the column is "Standard Report Column": enter image description here

This Display Type renders the HTML; some other Display Types escape it.

Related questions

How do I auto-resize an image to fit a 'div' container?

How do you auto-resize a large image so that it will fit into a smaller width div container whilst maintaining its width:height ratio? Example: stackoverflow.com - when an image is inserted onto the editor panel and the image …

Read More
How to display Base64 images in HTML?

I'm having trouble displaying a Base64 image inline. Can someone point me in the right direction? <!DOCTYPE html> <html> <head> <title>Display Image</title> </head> <body> &…

Read More
Responsive image align center bootstrap 3

I do a catalog using Bootstrap 3. When displayed on tablets, the product images look ugly because of their small size (500x500) and a width of 767 pixels in the browser. I want to put the image in the center of the …

Read More