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 an APEX Tech Lead DRW. I have worked with Oracle since 1995 and done eBusiness Suite implementations and customizations. Nowadays I specialize almost exclusively in Oracle APEX.

19 Comments on “Video: Part 1- APEX Classic Report Named Column Templates

  1. Jorge,

    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.

    Thanks,
    Jeff

  2. 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.
      Thanks!

  3. Thank you for the instructive video. I’m on Apex 18, and on my installation “Partial Page Refresh” defaulted to “No”. You said to keep it to “Yes”. I missed that initially. So for anybody else who find out that there refresh is not working with the dynamic actions, it’s because of this setting.

I love comments, write me a line