After hours of research and several attempts, I still haven't been able to figure out a way to export a report in CSV format. I can't use an Interactive Report as the view I am displaying on the report is larger than 100 columns. Although all the columns are displayed on the report,the CSV Output link doesn't export all the columns. Can anyone help me out? I would really appreciate it.
Thanks a lot.
Maybe you can look at this package to produce your xslx file: Create an Excel-file with PL/SQL</title> //<title>AMIS Technology Blog &raquo; Create an Excel-file w…
You will still have to produce code to either download it to the user or send it to them via e-mail...
Were we looking at the same page? That page shows an ORACLE PACKAGE that you can modify if need be to get what you want. It's NOT a plugin with wrapped code..
(You need to look for this line in the blob: The source code for the package: as_xlsx)
I haven't tried it, but would it be possible to pre-format groups of columns as single csv formated columns, thus reducing the total number of effective columns, if this suits your business requirements.
It may require a separate report specifically for csv export.