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.