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.
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
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!
Ha, so simple. Thank you!
That was an excellent presentation. Very useful!
Great topic ! thank you
You’re welcome. Thanks for watching!
Seeing you doing this kind of stuff makes it so much easier to use it. Thank you!
You’re welcome. That’s great to hear!
Thank you for sharing great stuff
You’re welcome!
can you share code with me regarding drag and drop
http://rimblas.com/blog/2016/08/implementing-drag-drop-in-your-apex-applications/
greate stuff here. Thank you for sharing your knowledge with us
Hi,
can you share how to use template for highlighting particular rows ?
https://rimblas.com/blog/2014/05/using-conditions-with-column-templates/
And you can check out my presentation “Hooked on Classic (Reports)” and “Of course, you can do that with APEX! Report Templates; the definitive guide”
https://rimblas.com/blog/presentations/
I have tried this in apex 18.1 version but its not working for me.
There are many reasons why. But I’m going to suspect Alternating Rows is still on. Turn it of in the Report Attributes Template Options
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.