Friday, June 10, 2011

Dynamic Interactive Reports

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.

2 comments:

MWrynn said...

"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.

Scott Horowitz said...

Our ERP based viewer has 125 columns.. using an APEX collection maxes out at 50...

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...