Overblog
Folge diesem Blog Administration + Create my blog
Neueste Posts

PL-jrxml2pdf - Version 1.1.3.4 - new major features

30. Dezember 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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
  • XY-linecharts
  • timeseries-linecharts

Here's a screenshot of a report containing all of them.

jrxml charts overview

Text-rotation

Text (both static text and textfields) can now be rotated.

Enhancements and bugs

There are also some smaller enhancements and several bugfixes included. See the package-documentation and version-history for details.

Weiterlesen

PL-jrxml2pdf - features for next version

8. Dezember 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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:

  jrxml2pdf barcharts

Also, it is now possible to have rotated text.

You can try out the actual version on apex.oracle.com.

I hope to publish a release until the end of this year.

Weiterlesen

PL-jrxml2pdf - implementing the charting-part

23. Oktober 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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 could be implemented using pure PL/SQL. I did some first steps and my answer is, it is possible, but a lot of work. And there will be some restrictions due to the restrictions of the PDF-version used (there is no support for transparency in PDF 1.3).

But as there are currently no other features which i want to introduce into PL-jrxml2pdf i'll give it a try. So, i started developing a pure PL/SQL-charting engine, which will work together with the PL-jrxml2pdf-reports-generator when finished.

Here a screenshot of my first test-chart build with my package:

jrxml2pdf charts

Weiterlesen

PL-jrxml2pdf - Version 0.9.0.0 - new major features

12. Oktober 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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 the documentation for details. Here's a demo-report

jrxml html

Map-component

You can now render google-maps using the map-component and the Google static maps API. Again, have a look at the documentation for details about the usage.

jrxml map component

Weiterlesen

PL-jrxml2pdf - Version 0.8.0.0 - new major features

9. September 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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
  • summaries at start or end
  • positioning of row- and column-headers
  • access to summary-variables at detail-level
  • crosstabs-splitting on page-end or column-end
 

NLS/Locale

You can now use multi-language-reports. Supported features are

  • Usage of resource-files (including unincode-chars)
  • Usage of $R{} syntax in expressions
  • Usage of msg()-function
  • auto-detection of date-, time-, and number-formats depedning on locale and or nls
  • support for date-formats short, medium, long and default

 

Here's a screenshot of a crosstab-report

jrxml crosstab usage

Weiterlesen

PL-jrxml2pdf - Version 0.7.0.0 - new major feature

3. August 2012 , Geschrieben von Andreas Weiden

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
  • nested columngroups
  • conditional rendering of columns (only top-level, not inside columngroups)
  • border around table-component.

 

Especially the conditional rendering is a nice feature, when the print-when-expression for a column or column-group returns false, the column or column-groups is not rendered and all columns right of it are moved to the left.

jrxml2pdf table usage

Besides this there are a lot of minor enhancements and several bugfixes included.

Enhancements
  • The property "mode" is now supported, so that objects without a color and mode not set to "Opaque" are transparent and therefore have the color of the underlying object
  • the property verticalAlignment is now supported for Static text and textfields
  • Added expression-support for
    1. ! as NOT
    2. .startsWith(EXPRESSION) as LIKE (EXPRESSION || '%')
  • support for properties pen/@lineWidth and pen/@lineColor in various objects
Bugfixes
  • "Stretch with overflow" in combination with paddings caused missing textparts in multiline text
  • Styles with names longer than 20 chars where cut off and not applied
  • Parameter expressions ($P{}) where not parsed
  • when a frame's content was extended in height, the fill-area for the frame was not adjusted
  • Special handling of parameter SUBREPORT_DIR
  • empty expressions lead to endless loop
  • bandheight could be smaller than minimum bandwidth when using subreports (Thanks to Tom Petrus for providing a solution)
  • fine-tuning of borders, especially when forming boxes
  • Style-correction: Bold/Italic from style not used
  • Style-correction: Boxline-colors and widths from style not used

 

 

 

 

I hope you enjoy it.

Weiterlesen

PL-jrxml2pdf - Version 0.6.3.1

13. Juli 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

Today i released a new version of PL-jrxml2pdf on the download-page.

There was an issue with version 11.2.0.3.0 of the database, where the generator simply stopped in the middle of processing. The issue was fixed.

Weiterlesen

PL-jrxml2pdf - Version 0.6.2.1

1. Juli 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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.

 

apex application

The installation of the APEX-application also installs all necessary db-objects and sample data, so that there is no need to do manual steps in SQL-plus. Make sure you install the supporting objects during the application installation.

Weiterlesen

First public release of PL-jrxml2pdf

28. Juni 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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

 

A big "Thank you" to my beta-testers, Tobias Arnhold and Klaus Friemelt.

 

I hope you like the tool, i'm awaiting your feedback.

 

Weiterlesen

jrXml to PDF - betaversion released to certain testers

28. Mai 2012 , Geschrieben von Andreas Weiden Veröffentlicht in #APEX

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 of supported features

  • Region-types

Title-region

Pageheader-region

Columnheader-region

Detail-region

Columnfooter-region

Pagefooter-region

Summary-region

Background-region

  • Subreports
  • Groups with header and footer
  • Styles (including conditional styles)
  • frames (also nested)
  • conditional rendering
  • Static text
  • lines
  • rectangles
  • Textfields with expressions
  • images
  • manual page breaks
  • graphical attributes (apply to several itemtypes)

fonts, fontsizes and styles (standard pdf-fonts)

foreground and background-color

borders

paddings

Format masks (field patterns)

 

Here's a screenshot from a generated pdf which shows the EMP-hierarchy in a somelike graphical way. The report definition makes use of multiple conditional detail-bands for the different levels of indeting and conditional lines for the "tree-lines":

jrxml2pdf emptree

Weiterlesen
<< < 1 2 3 4 > >>