Tuesday, December 02, 2014

NextReports: Single Table / Pivot Widget

NextReports Server can show inside a dashboard as many widgets as you like. But sometimes when you need all the space available, a single widget is desired. This may be the case when you have a table or a pivot widget.

To use as much space as possible dashboard must have a single column. Also dashboards tree may be hidden:

The problem in versions 7.3 and previous is the height of the widget which has a fixed value. This is good in case two or more widgets are found inside a dashboard:

But if a single table /pivot widget is found, it would be nice to have the height 100%. So, newer versions of NextReports Server will take this into account, allowing for full space expansion:

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