Video: Part 1- APEX Classic Report Named Column Templates

As part of my Kscope16 presentation “Hooked on Classic (Reports)
Learn tips & techniques to make them sing” (live slides here). I demoed a Classic Report with a custom template (a Named Column template), made to look like a list. I thought it would be useful to show all the steps of how that demo was built.
The full video is 36 min. however, only the last 16 min are for the building of the template example. When you’re done with this one, watch the follow-up video where I extend the functionality with some useful Dynamic Actions.

Note: If you only care about the building of the template, skip to min 20 in the video.

APEX Classic Report Named Column Templates from Jorge Rimblas on Vimeo.

If you like this format, and you like what you see, please let me know in the comments or twitter.

Next: Part 2

Hi, I'm Jorge Rimblas. Father, husband, photographer, Oraclenerd, Oracle APEX expert, Oracle ACE, coffee lover, car guy, gadget addict, etc... I'm a Senior APEX Consultant with Insum Solutions, a consulting firm specialized in Oracle databases and the APEX development tool. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.

14 comments on “Video: Part 1- APEX Classic Report Named Column Templates
  1. Jeff Stephenson says:


    I thought the format was great. The audio was very clear and it is an interesting topic. I do look forward to the finished example not too mention an example on drag and drop ordering.


  2. rubyfindings says:

    Thank you for high quality presentation, but where did you use “fa fa-square-o”? I saw just checked marks. When

    check = ”

    according to

    decode(completed_by, null, ”)

    it renders as

    i class = “fa fa-square-o”

    isn’t it?

    • Very good catch! THAT is an honest to goodness bug. I noticed it too after reviewing the video and expected to address it on the next one.
      What happens is that there’s a Classic Report attribute called “Show Null Values as” which defaults to a dash. So, effectively our decode returning NULL turns into ‘-‘ and breaks the class.

  3. That was an excellent presentation. Very useful!

  4. Mohamed says:

    Great topic ! thank you

  5. Geert Joosten says:

    Seeing you doing this kind of stuff makes it so much easier to use it. Thank you!

  6. Pranav Shah says:

    Thank you for sharing great stuff

  7. Pedro Fonseca says:

    greate stuff here. Thank you for sharing your knowledge with us

6 Pings/Trackbacks for "Video: Part 1- APEX Classic Report Named Column Templates"
  1. […] you installment Number 2 of this video series. If you missed the first one, you can find it here Part 1. In this 39 minute video you’ll […]

  2. […] see me working on the list created in the previous episodes (Part 1 and Part 2) and transform it to something a lot more […]

  3. […] future these blog posts I will explore the very powerful named column […]

  4. […] you’ve seen some of my videos, Part 1 covers the creation of the template that is mentioned below. In installment 004 I’ll be […]

  5. […] see me working on the list created in the previous episodes (Part 1, Part 2 and Part 3) and add the necessary JS to […]

  6. […] However, freezing columns is a completely different technique from freezing a header, or it requires special markup. Ideally, I didn’t want to create a Custom Template (even though, you know, I’m a big fan). […]

I love comments, write me a line