Monday, November 24, 2014

NextReports & MS Acccess

NextReports will be able to create reports on MS Access Databases from version which will come after 7.3. (it may be 7.4 or 8.0, time will decide)

The newly born Java 8 has pushed Java driver implementations in a good direction. Java 8 has removed the JDBC-ODBC Bridge functionality. Now, database vendors without a pure Java JDBC driver are forced to create such drivers.

UCanAccess is a relatively new open source JDBC driver which allows to read/write Microsoft Access database. NextReports is now using it.

A simple connection definition has to specify the full path to access database file:


A new dialect was added and users can now create Next reports as with any other supported type of database:


Friday, November 21, 2014

NextReports Designer: Name Pattern for Tables,Views and Procedures

Forthcoming release of NextReports will allow, after connecting to a data source, to set a 'name pattern' for Tables, Views and Procedures. This is useful in case you know the names of those entities you want to use in your queries reducing the time of loading. There may be thousands of tables in your database, so to have a filter is a nice addition.

'Name Pattern' is just a right-click action on Tables,Views and Procedures nodes from structure tree.


Users just enter a pattern using % sign (in this example we want all tables that start with BILL):

The Tables node will contain only filtered tables:


Friday, October 10, 2014

NextReports: Docx Exporter

NextReports can supply many export formats for generated files like PDF, HTML, EXCEL, RTF, XML, CSV, TSV, TXT. Starting from version 7.3 DOCX can be also used.

Generated docx files must be seen with Word Microsoft Office 2007+. Other free applications like LibreOffice or OpenOffice may not be able to correctly render the file, especially if features like "new page", "vertical merge", "html text" or "sub-reports" are involved.

Docx exporter has also some restrictions:
  1. "Page number" variable can be used inside header or footer band, but alone. If you use more cells, they will be ignored.
  2. "Total Page number" variable has no support.
  3. "Background image" has no support.
Designer action bar contains now the newly exporter:


Sample "Timesheet" report, that comes with demo database, has the following result as a docx file:



Wednesday, October 01, 2014

NextCharts: Dual Y Axis

NextCharts can present any number of series on an existing chart. Chart type can be one of line, area, bar and even combo bar-line to allow for comparison results.

But there are cases when there it is needed to compare series with data of different order of magnitude. In such situations some series may look flat. To prevent this, NextCharts offers now the possibility to add a second Y axis.

Json definition may now contain 3 new properties:
  • dualYAxis: true means second Y axis will be shown
  • y2Count: this is the number of (last) series that will be represented on second Y axis (by default it is one)
  • y2Legend: legend for second Y axis
 In next image it can be seen that the "Profit" line series is represented on second Y axis.

These properties will also be found in NextReports Designer's chart layout from version 7.3

Monday, September 29, 2014

NextReports: Excel Sheet Name

When a report is generated as Excel, sheets are named as "Page1", "Page 2" and so on. This is hard coded till version 7.3.

But starting with 7.3 version a new 'excel sheet name' property is used to address this issue.


If this property is left empty, sheets will have names like 1, 2, 3, ....

If user wants to use it, he has three options:

  1. Use a static list of strings: This is useful if you know from start how many sheets you have. For example A;B;C;D will name the first four sheets in this order as A, B, C, D.  If there are more sheets than elements in the list, next sheets will have their page number as name.
  2. Use a template  marker for page number ${NO}. For example Page ${NO} will name the sheets as Page 1, Page 2, Page 3, ...
  3. Use a template marker for group name ${G1}. This is useful if you have a group and you set "new page" after the group finishes, so you have group specific data on different sheets. In this case the sheets will be named with the group name. If there are more sheets than groups, next sheets will have their page number as name.