Within our ERP package, we have what are called "Viewers".. these are basically, a list of Views we've created to allow customers to view data and download to excel. On Apex, I needed a way to dynamically show these in interactive reports. One of the issues I was facing, is that interactive reports require Static SQL, not functions returning SQL.
I found this site which came in real handy for achieving what I wanted
http://www.oracleapplicationexpress.com/tutorials/71
One limitation that was hard though was the 50 column maximum.. however, thinking in Web based verses client based.... loading a report with more than 50 columns will be extremely slow.
Subscribe to:
Post Comments (Atom)
How Generative AI can save you time programming menial tasks
To paraphrase the rock band Staind, It's been a while since I blogged. And since every tech blog these days is talking about AI, I fig...
-
It's been a while since I updated for 2 reasons I'm extremely lazy with posting and keeping up with things I really haven't done...
-
To paraphrase the rock band Staind, It's been a while since I blogged. And since every tech blog these days is talking about AI, I fig...
-
Within our ERP package, we have what are called "Viewers".. these are basically, a list of Views we've created to allow custom...
2 comments:
"One limitation that was hard though was the 50 column maximum"
Are you saying this limitation was hard to deal with, or hard to implement? Just trying to understand.
Our ERP based viewer has 125 columns.. using an APEX collection maxes out at 50...
Post a Comment