Can't find what you are looking for? Try these pages!

DataFlex Reports 6

What's New in
DataFlex Reports

DataFlex Reports 6.2

Crosstabs

The biggest new feature and major improvement delivered in v6.2 is the introduction of crosstabs (also known as pivot tables). Crosstabs allow displaying data in a table where summaries are automatically calculated.

With crosstabs you can make a report showing summaries over grouped data per category, such as the amount of sales per shipping method, per payment condition.

New formatting and conversion functions

A number of new built-in formatting functions have been added. These functions allow you to convert data - such as date, time, number, currency and integer - using a mask or the Windows default setting.

A number of conversion functions have also been added which allow you to specify sizes and positions – in inches, centimeters or points – independent of the Windows locale settings of the machine on which the report runs. This enables changing the layout of the report on the fly.

DNS-less connection string builder

A connection to an ODBC data-source can be made via a DSN (Data Source Name), or via a connection string containing all the details which is also known as a DSN-less connection. The creation of this DSN-less connection is now easier with the enhanced ODBC connection wizard in DataFlex Reports Studio. The wizard also supports SQL Managed Connections that were introduced with DataFlex 2017 (v19.0). The information is read and converted into a DSN-less connection.

Import/Export of RDS data

RDS (Runtime Data Source) table structures and sample data can now be imported and exported. This means you no longer need to re-enter the RDS table structure for each report in which you want to use the table or re-enter the RDS sample data after you have made changes to the RDS table structure. The RDS data is stored as JSON in a separate file which you can easily copy between workstations.

Improved Excel Export

A new option ‘Export data using native Excel datatypes has been added to the Excel export. When using this option all data types are converted to unformatted native Excel data types. This makes it easier to make changes to the exported data in Excel.

DPI Scaling support

Both the DataFlex Reports Studio as well as the integration library now support DPI scaling in toolbars, menus and context menus. New icons were designed replacing the bitmaps used before to support DPI scaling.

Other features and bug fixes

A number of other features and enhancements are delivered with DataFlex Reports 2018, as well as bugfixes on reported issues.

  • Side-by-side assembly
  • Data-source connection errors option
  • Bigint support
  • Improved Barcode support
  • SQLite driver
  • Median support
  • New reset page number logic
  • Improved HTML export
  • CLOB and DBCLOB support for IBM DB2
  • Options from an older DataFlex Reports installation can be copied during installation
  • DF_material support for the integration library
  • Ability to show/hide row numbers in the RDS table definition and RDS sample data dialogs
  • Function to collect the FilterInformation in a report for the integration library
  • Function to convert the RDS data collected during integration into a JSON file 

Quick links

DataFlex Reports 6.1

Overview DataFlex Reports 6.1

Version 6.1 of DataFlex Reports includes a number of new features and enhancements as well as important bug fixes. Version 6.1 installs side-by-side with prior versions (such as 6.0). To gain 6.1’s benefits, just attach the v6.1 library and re-compile your DataFlex application for transparent report integration. Most important changes in this new version:

  • Support for DataFlex 2017/19.0s Managed Connections
  • Added Russian translations and collate definitions
  • Added Hungarian translations
  • Navigating in the report explorer pane now selects the object in the designer tab
  • Added option to show sub-reports in the Function Explorer
  • Added find by function ID option to the Function Explorer
  • Added import registration information to the registration dialog
  • Updated documentation
  • Bug fixes

To see all bug fixes take a look at this news article. Click here to download DataFlex Reports 6.1

DataFlex Reports 6.0

Embedded SQL

A new built-in function SQL() has been added to DataFlex Reports 6.0 which allows you to execute SQL statements directly (also known as SQL expressions). This function is only available for ODBC datasources and is a powerful addition to report developers. However, only a single value can be returned from a SQL() function.

Functions and function editor

A new case statement has been added to version 6 of DataFlex Reports. The case statement supports comma separated lists of values and does not allow fall-through to occur. Case statements can be nested. In addition to the case statement, whenever a function error occurs, the function editor is opened and the symbol which caused the error is highlighted. Selected text can now be commented and uncommented using the Ctrl+K, C and Ctrl+K, U keys or toolbar buttons. Additionally line comments can be toggled using the Ctrl+/ key.

Performance improvements

Version 6 of DataFlex Reports contains many performance improvements to optimize the report generation process. A function pre-compiler has been added which makes reports with lots of functions run up to 10(!) times faster; the performance of summaries (both summary fields and the Sum() function) has also dramatically improved. Additional changes have been made to the layout engine to streamline the report generation.

Barcode support

DataFlex Reports 6.0 supports over 70 different types of symbologies (type of barcodes) both onedimensional and two-dimensional (stacked) symbols are available. Fields (like database fields, functions or parameter fields and text objects) can be converted to a barcode with a simple mouse click and can be exported to PDF, RTF, HTML or image.

Bug fixes and see all changes

DataFlex Reports 6.0 includes over 30 implemented user suggestions and bug-fixes.

To see all the changes in DataFlex Reports 6.0 click on one of these links: Developer and Standard. And read more about this subject in this news article.