When selecting from data sources in the New Report Wizard or the Database Expert, you can select tables from multiple databases in the same SQL Server instance.
Since reports are limited to a single data source, this allows developers to link data from multiple databases in a report. This ability is limited to SQL Server.
This feature is for languages that are written from right to left. If you want text in a field to be right-aligned, set the Horizontal Alignment on the Common tab of the Field Properties dialog to Right.
Linked columns must be of the same type, but can have different sizes. This is useful, for example, to link to older versions of the same or related tables whose length may have changed over time.
For example, you can now link an int column of length 8 to an int column of length 4, or even different integer types, such as smallint to int. Keep in mind that linking columns of different sizes can result in not being able to match all data.
For example, a report may try to link a value in an int columm to a smallint column; when that value is outside the range of the smallint column (e.g. >= 32,768) it will not succeed.
You can right-click on any MS SQL Server table in the Field Explorer and select Show Full Name from the context menu to see the full table name, including database and schema.
This is useful when multiple databases or tables contain the same, or similar names.
There are several OnPrexxx and OnPostxxx events in the cDRReport class that can be used to tweak the output, control titles, log SQL queries, etc. These events are now also available for the HTMLPreviewData. Besides finetuning its also useful when debugging. For example you can show the used SQL statement in a log.
In DataFlex Reports 2022 a comboform is added to the cDRCurrentPageMenuItem class. This option makes it easier to select a different page.
The choice between a spinform or a comboform is controlled by a new property of the cDRReport object named piPageMaxCombo.
The cWebDRReportViewer class has been extended with support for an export report operation.
The event OnExportReport has been added to the cDRReport and cWebDRReportViewer classes. It fires when pbServerOnExportReport is set to true (default false) and the pbShowExportButton is set to true (default false).
A new feature in DataFlex Reports 2022 is support for multiple databases (if using MSSQL) from a single database server in one report. In previous versions, it was only possible to use tables from one database.
The psTableCatalog property allows getting the current and changing the catalog name in an existing report at integration level.
DataFlex Reports Studio is a 64 bit, fully unicode, report designer. Using a 64 bit OCX the Studio is capable to work with larger sets of data and based on unicode source data.
The integration library that can be installed with the DataFlex Reports Developer Edition Studio can be used for both 32 bit (DataFlex v19.0, v19.1 and v20.0) applications as well as with pure 64 bit applications (DataFlex v20 only). There are two sets of deployment files but there is no difference in coding needed.
Deployment of applications using DataFlex Reports has been made easier via the new runtime installers. There is a runtime installer for 64 bit and for 32 bit.
This is a new integration feature.. An existing sub-report can be - in memory - replaced by a different one loaded from disk. This opens a feature many developers used in the past where a sub-report was used to show a company 'letter' head.
A new report-by-report option to automatically stop report execution in the DataFlex Reports Studio when an error is detected. For example an database (SQL) error which would otherwise appear a zillion times.
DataFlex Reports Studio now supports saving the report structure in JSON format. This can be used to make comparisons between two versions of a report and can be used to quickly make changes such as connection string changes in multiple reports. After changes have been made the JSON file can be read in again and the report can be saved in the usual .DR format.
A number of other features and enhancements are delivered with DataFlex Reports V8, as well as bugfixes on reported issues.
The report developer can now change position and size of objects and more within the report viewer. Starting with DataFlex Reports 7.0 you can revise the report layout when previewing the report. No more need to go back and forth between the design and preview when making layout modifications, simply change the layout from the preview tab and the results can be viewed immediately. This can be a great time saver especially when fine-tuning the report design.
In DataFlex Reports 7.0 you can set a locale per report, allowing you to create reports intended for different locales without having to change your windows settings. This also allows you to deploy reports for different locales on a single (web) server.
DataFlex Reports uses a new modern product installer. The layout is restyled, it is 64 bit ready and it uses MSI techniques.
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.