APEX IR XLSX Downloader V1.3.0

After a long time I have finally published Release 1.3 of my APEX IR XLSX Downloader.
And because I kept you waiting so long there's one goody included.

Added Features

• The Interactive Report region ID is now automatically derived if not specified or set NULL.
• Function get_version which emits the package release you are running.

Bugs Fixed

• Column header wasn't filled if user didn't give a custom name for a function column in "Group By" view.
  Now the package puts similar names to what the APEX engine generates.

New Demo Application

There is also a new demo application available for download.

You can download it here and install into your own APEX workspace.

As always the source code can be found in the GitHub Repository.

ZIP files for all my GitHub projects can now be found on my GitHub Page.

Enjoy ;-)

APEX IR XLSX Downloader V1.2.3

I have just published Release 1.2.3 of my APEX IR XLX Downloader.

André Meier had a look at my package after DOAG 2014 and pointed out some hick-ups he encountered while using it.
He also made a big effort to bring some proper code formatting and explicit conversions into the XLSX_BUILDER_PKG which is one of the libraries used.

A huge thank you to André, as many of the changes are based on his contribution.

Changes

• XLSX_BUILDER_PKG
• Explicit Conversions
• Code Formatting
• Better CLOB building using VARCHAR2 buffer (as shown in a previous post)
• APEXIR_XLSX_PKG
• If splitting report_columns string would produce a NULL index this is now taken care of and a warning is send to the APEX debug messages.

As always the source code can be found in the GitHub Repository.

ZIP files for all my GitHub projects can now be found on my GitHub Page.

The new demo application is currently under development and will be published soon.
I'm currently creating some sort of packaged application which will better showcase all the different options available.

Stay tuned for more to come.

APEX IR XLSX Downloader V1.2.2

I have just published release 1.2.2 of my APEX IR XLX Downloader.
While attending the DOAG 2014 Conference Dietmar Aust was trying out my package and guess what...
He ran into a bug, so thanks Dietmar for reporting this.

Bugfix

• Columns without help text break the download.

As always the source code can be found on GitHub.

ZIP files for all my GitHub projects can now be found on my GitHub Page.
For a small demo visit my Demo Application on apex.oracle.com.

APEX IR XLSX Downloader V1.2.1

Well, just three days ago I published release 1.2.0.
In the meantime I've been working on updating the README to give you all a better start.

This time there are no bugfixes included as it's only documentation.

Documentation Changes

• Added list of features
• Added current limitations
• Updated "How to Use" section

As always the source code can be found on GitHub.

ZIP files for all my GitHub projects can now be found on my GitHub Page.
For a small demo visit my Demo Application on apex.oracle.com.

APEX IR XLSX Downloader V1.2.0

I have just published a new minor release of my APEX IR XLSX Downloader.
This time I have fixed a bug regarding control breaks and added one enhancement to column headers.

Enhancement

• Help text as defined on IR column is now added as a comment to the column header in the spreadsheet.

Bugfix

• Control breaks with just number or date column are now working.

As always the source code can be found on GitHub.

ZIP file is available in my demo application.

APEX IR XLSX Downloader V1.1.3

I have just published a new bugfix release of my APEX IR XLSX Downloader.
This time I had to fix some bugs regarding aggregations.

Bugfixes

• Aggregation values are now always taken from the correct SQL columns.
• Columns without aggregations defined no longer break the formatting on rows with aggregation values.

As always the source code can be found on GitHub.

ZIP file is available in my demo application.

APEX IR XLSX Downloader V1.1.2

Just a week ago I published a release which supports getting the  GROUP BY report from an IR.
Like most new functionality this one isn't bug free either.
Therefore I have just published release 1.1.2 of my APEX IR XLSX Downloader.

Bugfixes:

• Package didn't recognize the special aggregate functions like COUNT_DISTINCT, RATIO_TO_REPORT_SUM and RATIO_TO_REPORT_COUNT.

Added Functionality:

• Internal function to convert column display order into column identifier.
  This will support lifting the column restrictions on GROUP BY reports in the future.

Source code can be found on GitHub.

Download available in my demo application.

Enjoy. ;-)