Top-Posts
-
jrXml to PDF - betaversion released to certain testers
Today i released the first "official" betaversion of my generator. It's now beeing testing by some experienced PL/SQL-developers. I hope to get feedback soon, and if it's (hopefully) positive, i will release the version to public. Here's a short list...
-
PL-jrxml2pdf - Version 0.6.2.1
Today i released a new version of PL-jrxml2pdf on the download-page. The functionality of the generator itself didn't change, but i included an APEX-application to manage all the PL-jrxml2pdf-objects and run reports directly in an APEX-application. The...
-
PL-jrxml2pdf - Version 0.8.0.0 - new major features
Today i released a new version of PL-jrxml2pdf on the download-page. The release contains two new major features. Crosstabs Supported are multiple column-groups, row-groups and measures measure-functions COUNT, AVG, SUM, HIGHEST, LOWEST, FIRST, NOTHING...
-
PL-jrxml2pdf - Version 1.1.3.4 - new major features
Today i released a new version of PL-jrxml2pdf on the download-page. The release contains two new major features. Charts You can now integrate charts in your reports. Currently the following chart-types are supported piecharts barcharts 3D-barcharts category-linecharts...
-
A card-like javabean
The task In some application i've seen a layout where the data is presented in a card-like style, having a picture to the left, a title on top and some text containing additional information. I liked the layout, so i decided that this should also be possible...
-
Building a treetable-like form (part 2)
The task My last post was about "building a treetable-like form", it ended with a functional version which didn't look very sophisticated. Lets change that. An example I'll use the same example as in part 1, the EMPLOYEES-table from hr. The approach The...
-
jrXml to PDF - a declarative, pure PL/SQL reporting engine
The task I'm working on APEX since half a year now and i really like it. I also think its quite "complete" regarding its functionality, besides... well, besides the reporting possibilities. There are several available solutions, but either they require...
-
PL-jrxml2pdf - implementing the charting-part
Last week i was in contact with a developer who wanted to use PL-jrxml2pdf in his project and was quite disappointed that there is currently no support for charts. So i had a look at what chart-capabilities Jasper-reports has and if something similar...
-
PL-jrxml2pdf - features for next version
I started implementing charts in PL-jrxml2pdf and the next release will have support for barcharts and piecharts. Here a screenshot of the current version: Also, it is now possible to have rotated text. You can try out the actual version on apex.oracle.com....
-
JRXML-Generator POC and sneak-preview available
After getting the huge number of 2 (in words two) responses to my idea of writing a JRXML-generator i decided that this is enough to try it. And 100% of the responses liked the idea to be able to create a report-definition from an APEX-page. So i build...
-
A generic search-functionality
The task APEX has a nice search-functionality to search all objects in the application by just entering one search-condition. From the result-page of the search you can then directly navigate to the pages where you can edit the found objects. My idea...
-
JRXML-Generator - betaversion released to certain testers
Today i released the first version of the JRXML-Generator and gave it to certain testers. The tool currently supports the following region-types: HTML-Regions with page-items Classic-report-regions Tabular forms Interactive reports (with conditions) Here...
-
PL-jrxml2pdf - Version 0.9.0.0 - new major features
Today i released a new version of PL-jrxml2pdf on the download-page. The release contains two new major features. HTML-markup If you have a datafield containing HTML, PL-jrxml2pdf can render it to PDF. Only a subset of HTML is supported, have a look at...
-
PL-jrxml2pdf - Version 1.3.0.0 - new major feature
After quite a long time without any bigger enhancements i had a little time to implement a new major feature in PL-jrxml2pdf. Variables You can now use variables e.g. for the calculation of aggregates. Variables can be used either at report-level or at...
-
PL-jrxml2pdf - Version 0.7.0.0 - new major feature
Today i released a new version of PL-jrxml2pdf on the download-page. The release contains one new major feature. You can now use the table-component of jrxml. Supported are by now tableHeader, columnHeader, detailCell, columnFooter and tableFooter-cells...
-
PL-jrxml2pdf and barcodes
It has been a long time since the last update of PL-jrxml2pdf. In the meantime i received several smaller bugs and enhancement-requests, which are maybe worth a new release of PL-jrxml2pdf. In addition, Anton Scheffer announced his package AS_barcode,...
-
An "Expand/Collapse"-Canvas Java-Bean
The task In one of the posts on the OTN forms forum last week there was a question of if there is something like an expandable/collapsable Component like its known from outlook. It seems there is no component like this at the time, so i had the idea to...
-
First public release of PL-jrxml2pdf
Today i released the first public version of PL-jrxml2pdf. The functionality is as described in the last posts. The download includes a (more or less) detailed documentation of the features. You can download the software from sourceforge.net using this...
-
Calling a form and passing a context
The task One common task in a forms-application is call one form form another one and give some context-information to that new form when calling it. In some cases you also want to get a kind of "return-value" when the called form is finished to that...
-
Do it silently
The task Another often asked question from the forum How can i supress that message FRM-40401..... when doing some programmatic COMMIT_FORM ? And its not only the COMMIT_FORM, it could also be EXECUTE_QUERY with the message FMR-40350... The logic behind...
-
Working with trees
The task Trees are a nice feature to present hierarchical data. And, since forms 5 they are available as standard components in forms. A lot of forum posts are related to trees and the way they are populated. I want to show some different techniques to...
-
Pasting Excel-data to a forms-block
The task There was a thread in the Forms-forum these days dealing with Copy&Paste-problems, especially with the question if its possible to copy whole rows into a forms-block. As this is structured data and. of course, forms doesn't know how do deal with...
-
Populating listitems dynamically
The task Listitems in forms are quite useful if one has to offer a smaller choice of values to the enduser. Often the values to be displayed have to be taken from another table, so the listitems values have to be read at runtime. Also, listitems are often...
-
PL-jrxml2pdf - Version 1.2.3.3 - first public version of JRXML-Generator
Today i released a new version of PL-jrxml2pdf. As a new major feature it includes a first version of the JRXML-generator, which allows the generation of a jrxml-report-definition from an existing APEX-page. Its included in the APEX-part of PL-jrxml2pdf....
-
PL-jrxml2pdf - Version 1.2.0.0 - new major feature
Quite shortly after the last release, but i had a little time to implement some new feature in PL-jrxml2pdf and released a new version on the download-page. Running two or more reports into one PDF This was something i already wanted to introduce in an...
