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.
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.
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.
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.
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.
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.
A number of other features and enhancements are delivered with DataFlex Reports 2018, as well as bugfixes on reported issues.
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.1s benefits, just attach the v6.1 library and re-compile your DataFlex application for transparent report integration. Most important changes in this new version:
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.
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.
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.
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.