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: