Skip to main content

Download DataFlex Reports - Developer Edition

Downloads DataFlex Reports DataFlex Reports - Developer Edition
Back to overview

DataFlex Reports - Developer Edition

Description

This version is developed with the software developer in mind. As a developer you can create and integrate reports in your application. In case of Windows applications, the reports and the appropriate runtime components, can be distributed freely along with your application.

Reports can also be integrated in web applications. For deployment, a small fee per server is required.

Features

  • Crosstab/Pivot-tables
  • Charts
  • Barcodes
  • Stand style reports
  • Label style reports
  • Page layers
  • Data Sources: DataFlex Embedded, ODBC, RDS, SQLite 

Screenshots

DR Studio - Designer
DR Studio - Preview Report
DR Studio - Field Properties
DR Studio - Database Expert
DR Integration - WebApp HTML Previewer
DR Integration - Windows preview
Publisher: Data Access Worldwide Version: 8.1 Publication: 29/06/2022 File size: 215.7MB

Support

Supported versions

  • DataFlex Reports 2022 / 8.1
  • DataFlex Reports 2021 / 8.0.x
  • DataFlex Reports 2019 / 7.0.x 

Prior versions

Download Prior DataFlex Reports versions 

This is the first update to DataFlex Reports 2021 v8. It carries version number 8.0.1.  The following changes are present in this release:

Studio

  • Added an option to automatically create a JSON file with the report definition when saving a .DR file. This option makes it easier to quickly see changes made in the report definition using tools such as GIT 
  • The option to show SQL stored procedures was broken, fixed 
  • Error in Manual activation dialog 
  • Function name input field shorter than before

OCX

  • Select case variable is not array error fixed 
  • Can’t find a row in DataFlex data when a German u-umlaut is used 
  • Page N of M was not shown correctly in translation 

Integration library 

  • Zoom factor comboform in Windows preview dialogs did not use the piPreviewZoom property value of the report resulting in a difference between previewer and value shown 
  • Support of peExportType in web as in Windows 
  • Create large/big integer RDS columns when length is larger than 11 
  • Set Objectname in RDS report to table.columname instead of columnname 
  • Add BOM character to v20 source code when DataFlex Studio option contains this option 
  • Support possibly filename change in CollectXXXExportOptions in DRexportOptions.dg 
  • Currentpage spinform in Windows preview dialogs now limited to the real page range 

Installer 

  • Dr.db file distributed was “dirty 

DataFlex Reports v7 runs side-by-side with older versions. Note that saving the report definition file (.dr) with v7 makes it not accessible with v6.2 or older anymore.

New features

  • Edit in preview
  • Locale per report
  • Updated integration library
  • Updated help

 

Important information for existing DataFlex Reports users:

Existing reports

The .dr (or .vrw for older reports) report definition format has changed between version 6.x and 6.2. If you save reports with this version of DataFlex Reports, you can no longer use them in previous versions.

Special caution with regards to this: when opening reports that were created with an older version it is advised to run the ‘check database’ option.

Font sizes are calculated differently in version 6.0 and up of DataFlex Reports. This can have an effect on the layout of existing 5.0 reports.

DataFlex Reports version 6 calculates font sizes differently compared to previous versions. This means the overall size of text may differ and can cause clipping of fields which did not occur in previous versions. Also, when using small fonts (less than 10 pts) the text may appear more greyish compared to previous versions.

String comparison in expression evaluator

String comparison in previous versions of DataFlex Reports (up to and including DataFlex Reports 6.0 Beta I) were case-insensitive. Starting with version 6 Beta II, a new option ‘Use case-sensitive comparison in functions’ has been added to address what should be considered a bug. For example the following function would return “case insensitive”.

The option ‘Use case-sensitive comparison in functions’ is turned on by default for new reports. Existing reports have this option turned off to ensure backward compatibility. We strongly recommend you keep this option turned on for all new reports and advise you check your existing reports and turn this option on if your report(s) do no rely on case-insensitive string comparison.

Please note only string comparison operators <, <=, =, >=, > and <> are affected by this option.

Integration library

For existing DataFlex Reports 6.2 Beta users, please re-attach the integration library in your web projects to ensure the JS and CSS files are up-to-date.

Before deploying please update the integration library in your workspace(s) and recompile your application(s). After attaching the 6.2 library to your workspace(s) you should run the ‘Scan for images’ option in the DataFlex Reports Studio project properties dialog to replace the BMP files in you project’s .cfg file with the new ICOns.

The cWebDRReportViewer class is updated. Please make sure you check the ‘Copy APPHTML\DataFlex Reports Folder contents’ checkbox after attaching the new integration library in your web projects.

The existing cWebDRReport class which was introduced in DataFlex Reports version 4 is now considered obsolete. The class is still available for backward compatibility but there are no functional differences between the cWebDRReport and cDRReport classes. The availability of web only properties and methods is determined by the project type (Windows of Web) being compiled.

Previous versions of the integration library wizard generated the events ‘OnProgressRecorsRead’ and ‘OnProgressFormatPage’ when creating code for a windows project. These events are no longer generated and the events can be removed from existing code if not altered.

Use of IS$WEBAPP in DataFlex Studio

To ensure the DataFlex Studio will correctly handle labels for GUI controls and avoid warnings in the problem resolution panel of the DataFlex Studio you should add the IS$WEBAPP to the Tools | Configure Workspace | Conditionals | Workspace #IFDEF conditionals for your DataFlex Studio version 16.0 - 19.0 Windows GUI applications.

Important Information – Please Read Carefully

Installation

DataFlex Reports 2018 – 6.2 is developed with DataFlex 19.0. If you do not have a version 19.0 Client License running on your PC, the setup will automatically install one for you.

DataFlex 16.x, 17.x, 18.x or 19.0 Studio license is required to use the Integration library which is part of DataFlex Reports 2018 Developer Edition.

DataFlex Reports 2018 – 6.2 can run side-by-side with previous versions of DataFlex Reports.

Supported platforms

  • Microsoft Windows 10
  • Microsoft Windows 8 excluding RT
  • Microsoft Windows 7 Home Premium or higher
  • Microsoft Windows Server 2012 including R2
  • Microsoft Windows Server 2008 including R2
    • All of the above are supported in 32 and 64 bit editions
  • Windows Terminal Services when using Windows Server 2012 or Windows Server 2008
  • Citrix XenApp when used in conjunction with other supported Windows operating systems

Registration

DataFlex Reports 6.2 will run as a 60-day trial version. If you start DataFlex Reports you will be asked to register your version. To register, you need to purchase a license. Registering will lift the trial period. After registering your license you have a 60 day period to activate your license. Make sure you have an internet connection, and simply confirm the activation.
Click here to learn where you can order your license.

Changes between Beta I and RC I

Changes:

  • Median support
  • New reset page number logic
  • Improved HTML export
  • CLOB and DBCLOB support for DB/2

Bug fixes:

  • https://support.dataaccess.com/Forums/showthread.php?62771-DR6-1-5-Using-a-complex-SQL-Statement
  • HDE 5433 Cannot create a report based on a Stored Procedure
  • HDE 5451 Paste in a textbox pastes text AND any object on the clipboard
  • HDE 5430 Parameters not removed after removing a Stored Procedure from a report
  • HDE 5437 Month name in English, long date in German
  • HDE 5506 Check database on a SQL based report does not detect changes (only when run a second time)
  • Fixed crash when a function in a CrossTab generates an error
  • Fixed problem when deleting a function which is used in a Chart
  • Fixed problem with copying between reports when copied from report is closed before pasting
  • HDE 5641 Problem with ’Total page count’ and ’Page N of M’ special fields when used with case statement

Changes between Beta I and Beta II

Bug fixes:

  • Fixed incorrect internal version id in the Maintenance utility
  • Fixed problem with dates in DataFlex driver
  • Fixed problems with missing DataFlex runtime files in the installation
  • HDE 5471/5406 https://support.dataaccess.com/Forums/showthread.php?62658-DR-6-2-Test-Findings fixed ‘Dialog failed’ error when creating a new report based on a SQL statement
  • HDE 5468 https://support.dataaccess.com/Forums/showthread.php?62658-DR-6-2-Test-Findings Fixed ‘index out of bounds’ error when creating report based on SQL statement via Database Expert
  • HDE 5470 https://support.dataaccess.com/Forums/showthread.php?62658-DR-6-2-Test-Findings Current connection in Database Expert does not show SQL statement
  • HDE 5469 https://support.dataaccess.com/Forums/showthread.php?62658-DR-6-2-Test-Findings Fixed ‘Table mismatches’ error when using Check database on a SQL statement report and changing the statement
  • HDE 5427 Fixed problem with umlaute character (accentuated characters)
  • HDE 5429 Cannot create SQL based report from Database Expert
  • HDE 5475 Wrong icon in toolbar
  • HDE 5449 ODBC connection wizard creates incorrect SERVER when using managed connections with MS-SQL
  • HDE 5434 Create DSN less connection does not allow you to specify a server not listed in the combo
  • HDE 5431 Managed connection list is not automatically populated and does not include connection information
  • HDE 5466 Incorrect data when using SQLite SQL statement
  • HDE 5461 Browse data does not work on SQLite database
  • HDE 5462 Weird characters when using SQLite database with accentuated characters
  • HDE 5291 Paint problem in Designer (design tab) when scrolling a label report horizontally

Library:

  • Added DataFlex 19.1 library
  • DF_Material support (new default theme for 19.1)

Changes between 6.1.5 and 6.2

New features:

  • Added Crosstabs (pivot-tables)
  • Ability to copy DataFlex Reports Studio options from the install program
  • Added SQLite driver
  • Added Connection string to ODBC connection wizard
  • Option to show errors when connecting to a Data source
  • Added formatting functions: FormatDate(), FormatTime(), FormatNumber(), FormatCurrency() and FormatInteger()
  • Bigint support
  • HDE 3312 Option for exporting to Excel in native datatype
  • Side-by-side support for the DataFlex Reports Studio
  • DataFlex Reports Studio is now DPI aware and has new icons
  • HDE 4104 Added Import and Export of RDS tables and sample data to RDS
  • Added ability to hide/show row number in RDS sample data dialog
  • Hide barcode text and default barcode type https://support.dataaccess.com/Forums/showthread.php?60737-DR6-0-Beta-2-Barcodes&highlight=barcode
  • https://support.dataaccess.com/Forums/showthread.php?62374-DR6-1-5-Barcode-option-not-available-for-parameters
  • https://support.dataaccess.com/Forums/showthread.php?62353-YAFR-ConnectionID-in-the-New-Report-Wizard&highlight=connection
  • Added functions for the position and size of objects https://support.dataaccess.com/Forums/showthread.php?55293-Two-more-suggestions&highlight=position
  • Added UnitInch(), UnitCm() and UnitPt() functions

Bug fixes:

  • HDE 5135 https://support.dataaccess.com/Forums/showthread.php?61986-DR-6-1-4-Setup
  • HDE 5019 Fixed broken link in the Control Panel’s ‘Programs and Features’ for DataFlex Reports
  • HDE 5040 ‘Size To Font’ option no longer allowed on barcode
  • HDE 5273 Fixed keys (line Tab and Enter) not working in search dialog
  • HDE 5146 Installer no longer removes DR registration files during uninstall
  • HDE 5224 Problem with position of Group Header in a subreport
  • https://support.dataaccess.com/Forums/showthread.php?62252-DR-craches-with-long-text-in-memo-field
  • HDE 5092 Exporting a report with Page Layers to Excel will result in blank lines
  • HDE 4523 https://support.dataaccess.com/Forums/showthread.php?59482-DR5-01-Export-to-XLS-does-not-start-at-Row-1
  • HDE 5266/5253 Fixed ‘Unable to read report (possibly damaged)’ error when report contains empty functions
  • HDE 5022 Fixed problem with empty (NULL) Memo and Binary columns displaying random characters
  • https://support.dataaccess.com/Forums/showthread.php?62288-Error-4509
  • https://support.dataaccess.com/Forums/showthread.php?62272-Output-to-PDF&highlight=PDF+opened
  • HDE 5030 https://support.dataaccess.com/Forums/showthread.php?62391-New-page-number-on-change-of-group-no-longer-working-(DR-6-1-5-9607)
  • HDE 5315 Find dialog does not get the focus
  • https://support.dataaccess.com/Forums/showthread.php?62439-DR-6-1-5-Issue-with-Text-Objects&highlight=cut+paste

Library:

  • HDE 5272 OnPreviewClick no longer redirects errors to cDRReport object
  • HDE 5178 Fixed bug in export file name
  • HDE 5293 https://support.dataaccess.com/Forums/showthread.php?62275-Function-TableNumber-is-not-resetting-local-error-handling
  • HDE 5281 Error message after pressing Help (F1) in Integration Wizard
  • Library is now DPI aware and has new icons

Changes between 6.1.4 and 6.1.5

  • HDE 5197 https://support.dataaccess.com/Forums/showthread.php?60060-Re-New-Version
  • HDE 5140 https://support.dataaccess.com/Forums/showthread.php?61963-Text-Object-Problem
  • HDE 4847 Collapse all option for Report Explorer
  • HDE 4481 https://support.dataaccess.com/Forums/showthread.php?59345-DR-File-Path-in-the-statusbar-please
  • HDE 5180 Fixed problem with purged functions
  • HDE 5127 Undo button does not work with Pagelayers
  • HDE 4834 Implemented Alt+Up and Alt+Down for Report Explorer and Experts
  • HDE 4440 Save or Save as of a report with a .vrw extension will change extension to .dr
  • HDE 5129 https://support.dataaccess.com/Forums/showthread.php?61964-Another-Problem

Library:

  • HDE 5178 DRExportOptions.dg sets the filename to the correct extension
  • HDE 5196 Fixed problem in Wizard when using Windows integration
  • HDE 5131 Fixed problem when clicking in preview before report has run

Changes between 6.1.3 and 6.1.4

  • HDE 4683 Keep RDS sample data after changing RDS database
  • Allow RDS name to be changed
  • HDE 5103 Fixed problem with reports bases on SQL statement with string parameters
  • HDE 5075 Fixed problem with RDS alias names
  • HDE 5104 https://support.dataaccess.com/Forums/showthread.php?61754-Using-SQL-Statement-with-Parameters-as-Report-s-Datasource
  • HDE 3618 Added row number column in RDS sample data dialog
  • HDE 5079 Fixed problem with purge functions not working in Maintenance tool
  • HDE 5072 Fixed problem with Shift-Click not working in the Report Explorer
  • HDE 5084 Fixed Invalid message ‘OnExitObject’ when focus moves to Report Explorer while editing a text object
  • HDE 5082 https://support.dataaccess.com/Forums/showthread.php?61766-Report-crashes-when-filtering-subreport-on-text-field
  • HDE 4691 Added ability to remove the collating sequence in report, the F5 key now resets to default collate
  • HDE 5098 Fixed problem with default column in Insert Group dialog
  • HDE 5082 https://support.dataaccess.com/Forums/showthread.php?61766-Report-crashes-when-filtering-subreport-on-text-field
  • HDE 5109 Fixed ‘Referenced array index out of bounds’ error in Report/Field Explorer
  • HDE 5112 Top & bottom border of a subreport are not printed when Page header / footer are hidden in the subreport
  • HDE 5107 https://support.dataaccess.com/Forums/showthread.php?61897-DR-6-1-3-Sub-Sub-Report-Alignement
  • HDE 5046 https://support.dataaccess.com/Forums/showthread.php?61615-Pressing-F1-for-Help
  • HDE 4918 https://support.dataaccess.com/Forums/showthread.php?61128-DataFlex-reports-RC-II-function-editor-annoying-thing-with-SHIFT-TAB
  • HDE 4931 https://support.dataaccess.com/Forums/showthread.php?61203-Clicking-on-SubReport
  • HDE 4865 https://support.dataaccess.com/Forums/showthread.php?60944-Multiple-Object-Selection-in-Report-Explorer&highlight=report+explorer
  • Updated integration library
  • Updated help

Changes between 6.1 and 6.1.3

  • Fixed type conversion problem in SQL() function
  • Binary data can now be stored in RDS sample dialog
  • Fixed problem with saving functions when switching between functions in the function editor
  • HDE 5062 Increased maximum font size from 100 to 500 pts
  • HDE 5035 Empty functions are no longer automatically deleted
  • HDE 5042 Fixed problem with background color for barcodes
  • Updated integration library
  • Updated help

Changes between 6.0 and 6.1

  • Managed connection support (use the ODBC driver to use the new Managed Connections)
  • Added Russian language & collate
  • Added Hungarian language
  • Navigating in the report explorer now selects object in the design tab
  • Added Show Subreports option to Function Explorer
  • Added Find by Function ID option to Function Explorer
  • Added Import registration information to Registration dialog
  • Updated documentation

Bug fixes:

  • HDE 4914 https://support.dataaccess.com/Forums/showthread.php?61045-DR6-0-RC-Crashing-after-quot-Check-Database-quot
  • HDE 4950 Page layers only appear on first two pages
  • HDE 4937 ODBC memo fields have a default height/length of zero
  • HDE 4959 Validate Collate file name in designer
  • https://support.dataaccess.com/Forums/showthread.php?61208-Adding-Stored-Proc-to-report
  • HDE 4939 OEM/ANSI translate problem in Windows menu
  • HDE 4958 OEM/ANSI translate problem when switching language
  • HDE 4955 Studio shows wrong function when error occurs in a subreport
  • https://support.dataaccess.com/Forums/showthread.php?61269-Where-is-my-report-data-This-version-6-00-is-really-a-nightmare!
  • Group numbers are off by one after printing a subreport
  • Added message to find in Preview when string is not found
  • HDE 5002 Fixed problem with screens appearing gray
  • https://support.dataaccess.com/Forums/showthread.php?61387-Can-you-please-make-this-space-wider
  • https://support.dataaccess.com/Forums/showthread.php?61384-Variable-Height-Fields&highlight=variable+height
  • https://support.dataaccess.com/Forums/showthread.php?61437-Creating-Label-Reports-shows-ERROR
  • HDE 5010 Crash when printing barcode without data
  • Fixed problem with NVARCHAR(MAX) fields not displaying any data
  • Fixed problem with variable length fields (Memo and Binary) not working in Filter Function for the ODBC driver
  • Fixed error on first argument of the Propercase() function

Library:

  • https://support.dataaccess.com/Forums/showthread.php?61403-OnReportPreviewClick-is-not-firing-in-DF-19-00
  • Improved feedback when a function error occurs, including the possibility to copy the Function ID and the ability to find the Function ID in the DR Designer.
  • HDE 4969 https://support.dataaccess.com/Forums/showthread.php?61242-DR6-Reports-NOT-printing-anymore-URGENT-!!!

Changes between RC II and Release

  • Updated documentation
  • Added option to integrate the DataFlex Reports help into the DataFlex 19.0 Help system

Bug fixes:

  • HDE 4909 Incorrect summaries when used inside a group based on a function
  • HDE 4886/4922 https://support.dataaccess.com/Forums/showthread.php?61137-Dataflex-Reports-6-RC-2-Crashes-with-Sub-Report-in-Windows-10
  • HDE 4915 Group Sort Expert changes the sum to sort on when navigating through the groups
  • https://support.dataaccess.com/Forums/showthread.php?61126-DataFlex-Reports-RC-II-Select-Case
  • https://support.dataaccess.com/Forums/showthread.php?61102-psPreviewWaitingGif
  • Fixed ’Invalid cursor state’ error when using SQL() function
  • Fixed problem with incompatible data-types returned from SQL() function

Changes between RC and RC II

  • Updated documentation
  • PreviewWaitingGIF() property added
  • Added option to set the ‘Wrap state’ of existing reports to the Maintenance utility

Bug fixes:

  • HDE 4835/4857 SUM function output differs between report/page header and footer
  • Fixed problem in PDF export when white background color was used
  • 4839 Fixed problem with PDF export, the ‘End color’ is used even when ‘Gradient Type’ is set to ‘Solid’
  • Fixed problem with arrange objects always changing the distance of both X and Y axis
  • Fixed problem with CASE statement not working with some datatypes
  • Fixed error message during registration (MAC address error)
  • https://support.dataaccess.com/Forums/showthread.php?56773-Page-Numbering-Bug&p=322510#post322510
  • https://support.dataaccess.com/Forums/showthread.php?60880-Report-SQL-Query-not-showing-all-filters
  • Fixed problem with removing sub reports
  • HDE 4841 ‘Invalid bookmark value’ error when using ODBC and OEM character set
  • Fixed problem with ‘set datasource location’ dialog displaying subreports in wrong treeview branch
  • Fixed error message on right mouse-click in ‘Check Database’ dialog
  • Fixed problem with weird sort order when using AddSortField() from integration library
  • Fixed problem with Excel export skipping every other line
  • https://support.dataaccess.com/Forums/showthread.php?60941-Look-at-the-differences-between-5-0-1-amp-6-00-it-s-blurry-It-is-not-subtle-at-all&highlight=blurry
  • https://support.dataaccess.com/Forums/showthread.php?56773-Page-Numbering-Bug&highlight=reset+page+number
  • Fixed error message when closing main report with multiple opened subreports
  • HDE 4878 Cannot delete – unused – parameter
  • HDE 4806 Fixed problem with formatting when printing RTF text over multiple pages
  • Fixed memory overwrite
  • Improved comment support in function editor
  • https://support.dataaccess.com/Forums/showthread.php?61043-Reports-2017-RC-Error-108-symbol-File-field-not-defined

Library:

  • The cWebDRReportViewer class is updated.
  • Added support for DataFlex 19.0 tab-workspaces
  • cDRPreviewWindow class now sends PreviewPaint when a resize occurs (for tab-workspace support)
  • 18.0 library and higher; web.tpl (template) replaced with webPDF and webHTML templates
  • 19.0 library; icon and bitmap update

Changes between Beta II and Release Candidate

Bug fixes:

  • HDE 4752 https://support.dataaccess.com/Forums/showthread.php?60524-Arrange-Object-spacing-possible-YAFR
  • https://support.dataaccess.com/Forums/showthread.php?60693-DR6-0-Display-Status-Panel-flickering
  • https://support.dataaccess.com/Forums/showthread.php?60704-Text-field-Don-t-work-with-special-characters
  • Exporting reports with charts in HTML and PDF draws the chart upside down
  • Chart legend marker ‘width’ and ‘height’ values were swapped
  • Fixed Barcode error messages
  • Fixed ‘invalid data type’ errors in copy/paste of subreports
  • Fixed problem with adding existing report as a subreport changing tab names in the Studio
  • Fixed problem with PDF passwords no longer working
  • HDE 4686 Paint problem with current selection of combo box
  • HDE 4762 First row on every page of Excel export is empty when using ‘Data only’ export
  • HDE 4764 Error opening Excel 2007 export file
  • Fixed problem with varchar(max) fields in ODBC being converted to ‘string’ fields instead of ‘memo’ fields
  • Fixed problem with summaries on functions not working properly
  • One or more table mismatches’ error in check database when using tables from multiple schemas
  • Changing the label size did not change the size of the details section
  • Fixed errors hen using some of the Barcode constants (constants with dash symbols)
  • Images on RDS are now 1 inch by 1 inch by default if no image sample is available
  • Fixed problems with copying/pasting objects between reports based on different data sources
  • Fixed error messages when copying/pasting from the report explorer

Changes between Beta I and Beta II

  • JIT function pre-compiler
  • Added option for case-insensitive compare in functions. We recommend you turn this option on for all new reports (by default this option is turned on for new reports and off for existing reports).
  • ’(null)’ values will no longer appear in RDS reports
  • Variable length Memo and Binary fields.
  • Anchor support
  • Helper for drawing Lines/Boxes over sections. You can create Lines and Boxes spanning multiple sections by inserting a Line/Box while holding the Ctrl key.
  • New ‘TableNameAlias’ function in OCX
  • Updated integration library

Bug fixes:

  • http://support.dataaccess.com/Forums/showthread.php?60036-DR-6-00-Barcode-Printing
  • HDE 4672 http://support.dataaccess.com/Forums/showthread.php?59388-quot-and-not-quot-not-working-anymore-DR-5-01
  • HDE 4673 remove and reorder table columns
  • HDE 4696 http://support.dataaccess.com/Forums/showthread.php?60073-DR6-slow!
  • HDE 4687 http://support.dataaccess.com/Forums/showthread.php?60080-Table-with-many-columns-produces-blank-output&highlight=lasso
  • http://support.dataaccess.com/Forums/showthread.php?57878-Subreport-in-Report
  • HDE 4724 Designer does not show italic fonts
  • HDE 4710 DR setup program installs the wrong DR.DB
  • HDE 4706 blank page after label report
  • HDE 4701 ’Referenced array index out of bounds’ error in designer
  • HDE 4700 Using section expert to change section height of label report
  • HDE 4698 Incorrect barcode colors used
  • HDE 4697 Barcode type constants are missing
  • HDE 4693 Unhandled program error when using extremely large fonts
  • HDE 4692/4694/4689 Unhandled program error when using spinforms with certain locale settings
  • HDE 4691 Export to HTML does not work with some images
  • HDE 4709 Export of barcode to PDF (high quality) does not work
  • HDE 4747 Invalid message error when aligning objects
  • Fixed error message for recursive functions

Changes between 5.0.1 and 6.0 Beta I

Implemented suggestions:

  • HDE 4612: Custom section names
  • HDE 4494: Extract page layer from report (see: http://support.dataaccess.com/Forums/showthread.php?59369-YAFR-Tool-to-extract-page-layer-back-to-DPL-file-from-DR-file)
  • HDE 4337/4203/3445: Add CASE statement to functions (see: http://support.dataaccess.com/Forums/showthread.php?58781-Wishlist-Case-statement&highlight=CASE)
  • HDE 4442: Select function in ‘Field Explorer’ after creation (see: http://support.dataaccess.com/Forums/showthread.php?59063-Suggestion-when-creating-a-new-function)
  • HDE 4637: Copy suppress condition using the ‘Same formatting’ option (see: http://support.dataaccess.com/Forums/showthread.php?59915-YAFR-If-it-doesn-t-exist)
  • HDE 3960: Ability to specify the default JOIN type in options
  • HDE 4580: Ability to copy fields between reports (see: http://support.dataaccess.com/Forums/showthread.php?52439-YAFR-Copy-amp-Paste-between-reports&highlight=copy+reports)
  • HDE 4660: Ability to get SQL statement for reports based on custom SQL (see: http://support.dataaccess.com/Forums/showthread.php?59001-Extracting-SQL-Statement-from-Report&p=310378#post310378)
  • HDE 1676: Support for Embedded SQL/SQL expression fields
  • HDE 4483: Open function editor on error
  • HDE 4661: Add function for ‘Group Sort Number’ option in the group expert
  • HDE 3985: Print multiple sections at bottom of page
  • HDE 4542: make Tables, Views and Stored procedures available when not selected in options (see: http://support.dataaccess.com/Forums/showthread.php?59468-Creating-new-report-in-Reports-5-0-don-t-show-my-stored-procedures&highlight=show+stored+procedures)
  • HDE 3389: Comment/Uncomment block in editor (see: http://support.dataaccess.com/Forums/showthread.php?52895-Few-Suggestions-amp-Bug-reports-for-next-release&highlight=comment)
  • 4665: Ability to change the canvas (background color) of a report from integration

Bug fixes:

  • HDE 4597/4466: ‘Size to font’ option clips data (see: http://support.dataaccess.com/Forums/showthread.php?59684-Possible-bug-Size-To-Font)
  • 4622: Default height of textbox differs from database fields
  • 4596: Different default function widths when inserting from menu (see: http://support.dataaccess.com/Forums/showthread.php?59698-Numeric-function-width-when-inserting-from-the-Menu)
  • HDE 4432: Function return type incorrect when calling another function (see: http://support.dataaccess.com/Forums/showthread.php?58996-Isn-t-it-time-that-the-functions-return-type-get-evaluated-correctly)
  • HDE 3166: Bug in ‘Database Expert’ (see: http://support.dataaccess.com/Forums/showthread.php?52071-Database-expert-bug&highlight=database+expert)
  • HDE 4578: Refresh of ‘Field Explorer’ jumps to wrong item after dragging a field
  • HDE 4599/4496: Page layers do not respect ‘Word wrap’ option (see: http://support.dataaccess.com/Forums/showthread.php?59699-BUG-Page-Layer-File-not-respecting-quot-Word-Wrap-quot)
  • HDE 4428: DR exits when using ‘Align to baseline’ on a text object and a line (see: http://support.dataaccess.com/Forums/showthread.php?58951-Small-bug)
  • HDE 4486: ‘Referenced Array Index Out of Bounds’ error when dragging a field while holding the Ctrl key
  • HDE 4550: Wrong icon for ‘Refresh’ in Report menu
  • HDE 4584: ‘Illegal datatype conversion’ error when using ‘Redo’ option in a subreport
  • HDE 4552: Delete row from sample RDS data does not work
  • HDE 4662: ‘Variable height’ field is missing the last line (see: http://support.dataaccess.com/Forums/showthread.php?59784-BUG-Print-of-a-variable-length-field-is-missing-last-line)
  • HDE 4663: Group sort within a normal group does not work
  • HDE 4664: Alias names are not updated when using the ‘Change Datasource Wizard’ to convert a report from RDS to RDS
  • HDE 4643: ‘Table XXX has no column named XXX’ error when the column does exist
  • HDE 4370: Reserved words in RDS column names (see: http://support.dataaccess.com/Forums/showthread.php?58497-Baffled!!-RDS-Prblem-HELP!)
  • HDE 4667: Report options dialog shows the wrong label sizes

Library:

  • HDE 4403: Replaced DownloadURL call in ExportReportToDownloadURL with CustomDownloadURL
  • HDE 4439: Implemented suggestion to add file extension to export filename if not specified in DRExportOptions.dg
  • HDE 4427: Repaint of preview after PreviewFind
  • HDE 4636: pbServerOnEscape set to true in DRPDFModalDialog.wo
  • HDE 4665: Added new method to set the color of the preview canvas
  • Moved the code previously generated by the wizard for the OnProgressRecordsRead and OnProgressFormatPage methods to the cDRReport class
  • Added new preview option for windows implemented in class cDRDesktopPreview Excluded all methods unavailable in web applications in cDRReport with conditional compiler switch
  • Moved all methods and properties from cWebDRReport to cDRReport, the cWebDRReport is now an empty class and the wizard will generate a cDRReport

Wizard Changes:

  • Added new preview option – DesktopView – similar to the tool-panel but with additional button in the windows task bar
  • OnProgressRecordsRead and OnProgressFormatPage methods are no longer generated

What is New in version 6.2?

Crosstab support

DataFlex Reports 6.2 introduces a crosstab field type (also known as a pivot-table) which allows you to display your data in a table. All summaries are automatically calculated or you can use a custom function for your summaries. In addition you have full control over how the lines, margins etc. in the crosstab are displayed. In order for crosstabs to work properly you should set the ‘Section can span multiple pages’ option for the sections in which crosstabs are placed. The crosstab wizard can automatically set this option for you.

Side-by-Side assembly

The DataFlex Reports Studio is now able to run as a side-by-side assembly. This means it no longer relies on any registered components to operate (also known as ‘regfree’) eliminating the risk of conflicts or missing shared components – such as CodeJock.

DPI scaling support

Support for dot per inch (DPI) scaling has been added to all toolbars, menus and context menus. In addition newly designed icons – ranging from small to large – have been added to the DataFlex Reports Studio and Integration Library.

New formatting and conversion functions

A number of new build-in formatting function 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 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.

DSN-less connection string builder

A connection string builder option has been added to the ODBC connection wizard for DSN-less connections. Depending on the driver you select you will be prompted for all the required information to create the connection. You can easily modify the connection string at runtime use the integration library included with the Developer Edition of DataFlex Reports.

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.

Datasource connection errors option

A new option ‘Show datasource connection errors’ is now available. With this option all errors which occur when you connect to a datasource are reported which can help you determine why you cannot connect to a particular datasource.


Import/Export of RDS data

DS (Runtime DataSource) table structures and sample data can now be exported and imported. 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.

Bigint support

Support for 64 bit integers has been added to all the Database drivers supplied with DataFlex Reports. If you use any 64 bit integers in your database(s) simply run ‘Check Database’ from the DataFlex Reports Studio or use the Maintenance utility to start utilizing this new data type.

Improved Barcode support

Barcode support has been improved with a new option to set the default barcode type and an option to display the humanly readable text which appear underneath some barcode types. Furthermore you can now change a parameter field to a barcode.

SQLite driver

SQLite is a widely used zero-configuration SQL database. It is used by DataFlex Reports for its internal data storage. The new SQLite driver included in DataFlex Reports is a native driver and does not rely on an installed ODBC driver or any other dependencies. Just like the ODBC driver the SQLite driver allows you to base your reports on a SQL statement and supports the SQL() function.

What is New in version 6.0?

Barcode support

DataFlex Reports 6.0 supports over 70 different types of symbologies (type of barcodes) both one-dimensional 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.

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.

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.

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 data-sources and is a powerful addition to report developers. However, only a single value can be returned from a SQL() function.

Suggestions and bug fixes

DataFlex Reports 6.0 includes over 30 implemented user suggestions and bug-fixes. See the ‘Changes’ section in this readme for a complete list.

Existing DataFlex Reports 4.x user information

All classes, constants and files in the DataFlex Reports integration – included in this version – have been renamed as part of the rebranding of the DataFlex Reports product. For existing pre-DataFlex Reports 4.0 applications create a backup of your existing project(s) and take the following steps to update to the 6.2 library:

Remove the existing DataFlex Reports library and add the DataFlex Reports 6.2 library to your workspace (this may require you to start the DataFlex Studio with administrator rights).

  1. 1Click the replace in files button in the Studio (Ctrl+Shift+H)
    1. Enter VRW in the “Text to Find” input field
    2. Enter DR in the “Text to Replace” input field
    3.  Click the “Replace All” button
  2. Open the <projectname>.cfg file
    1. Replace all VRW with DR for the icons and bitmaps
  3. Search for the usage of psDatabaseCollate and remove the code. The property does not exist anymore
  4. Windows projects
    1. Replace all occurrences of “cCJSortColumnsGrid” with “cDRSortColumnsGrid”
    2. Replace all occurrences of “cCJSortDirectionsGridColumn” with “cDRSortDirectionsGridColumn”
  5. Web Application Framework projects
    1. Replace all occurrences of “oPDFModalDialog” with “oDRPDFModalDialog”
    2. Replace all occurrences of “Use PDFModalDialog.wo” with “Use DRPDFModalDialog.wo”
  6. Optional:
    1. Replace all “.vrw” to “.dr” in the program code
    2.  Rename all reports with a VRW extension to DR

Language support

DataFlex Reports ships with support for a number of languages. Before changing the language used in DataFlex Reports you must set your Windows Regional Options to the language of your choice. This ensures that the correct (ANSI) code page is selected in Windows. You can change the Regional Options in the Windows Control Panel, for full language support you must change both the ‘Standards and formats’ option to ensure correct date and number handling and the ‘Language for non-unicode programs’ option. Please note that the name of these options may differ in various versions of Windows. After changing the Windows Regional Options you can change the language in DataFlex Reports by choosing a language from the ‘Language’ menu.

Integration library

DataFlex Reports comes with an Integration library. This library allows you to seamlessly integrate reports with your DataFlex 16.x, 17.x, 18.x or 19.0 applications. The library contains an Integration Wizard and classes for integrating and viewing reports. During installation you can specify the location of the Integration library. We suggest you install the library in a subfolder of the main DataFlex directory, this allows you to add the library using relative paths. To use the Integration library and Integration Wizard in your DataFlex projects and Workspaces you must first add the library. You can do this by opening the DataFlex Studio and select the ‘Maintain Libraries…’ option from the ‘Tools’ menu. Next, you can use the ‘Add Library’ button and open the ‘DataFlex Reports XXX.sws’ file. After selecting the .sws file and clicking the ‘Ok’ button a wizard will be started which will guide you through the process of adding the library to the currently selected workspace.
For windows application, simply choose the ‘View/Report’ option from the ‘File’ menu and select the ‘DataFlex Reports Wizard’ icon. For Web applications use the ‘Web Object’ option from the ‘File’ menu.

Reporting bugs, comments and suggestions

Please report bugs to Data Access via our HelpDesk Express application (https://hde.dataaccess.eu). Please create a new account if you do not have one currently. Make sure to provide as much detail as possible to define and reproduce the problem that you are reporting. Upon your report, you will be invited to use an account on our help-desk support system for reporting future issues. For further communications and information, there is a forum devoted to DataFlex Reports in the Data Access Worldwide Support Forums.

 

Important information for existing DataFlex Reports users:

Existing reports

The .dr (or .vrw for older reports) report definition format has changed between version 5.x and 6.x. If you save reports with this version of DataFlex Reports, you can no longer use them in previous versions.

Special caution with regards to this: when opening reports that were created with an older version it is advised to run the ‘check database’ option.

Font sizes are calculated differently in version 6.0 and up of DataFlex Reports. This can have an effect on the layout of existing 5.0 reports.

DataFlex Reports version 6 calculates font sizes differently compared to previous versions. This means the overall size of text may differ and can cause clipping of fields which did not occur in previous versions. Also, when using small fonts (less than 10 pts) the text may appear more greyish compared to previous versions.

String comparison in expression evaluator

String comparison in previous versions of DataFlex Reports (up to and including DataFlex Reports 6.0 Beta I) were case-insensitive. Starting with version 6 Beta II, a new option ‘Use case-sensitive comparison in functions’ has been added to address what should be considered a bug. For example the following function would return “case insensitive”.

The option ‘Use case-sensitive comparison in functions’ is turned on by default for new reports. Existing reports have this option turned off to ensure backward compatibility. We strongly recommend you keep this option turned on for all new reports and advise you check your existing reports and turn this option on if your report(s) do no rely on case-insensitive string comparison.

Please note only string comparison operators <, <=, =, >=, > and <> are affected by this option.

Deployment

Before deploying please update the integration library in your workspace(s) and recompile your application(s).

Integration library changes

The existing cWebDRReport class which was introduced in DataFlex Reports version 4 is now considered obsolete. The class is still available for backward compatibility but there are no functional differences between the cWebDRReport and cDRReport classes. The availability of web only properties and methods is determined by the project type (Windows of Web) being compiled.

Previous versions of the integration library wizard generated the events ‘OnProgressRecorsRead’ and ‘OnProgressFormatPage’ when creating code for a windows project. These events are no longer generated and the events can be removed from existing code if not altered.

Use of IS$WEBAPP in DataFlex Studio

To ensure the DataFlex Studio will correctly handle labels for GUI controls and avoid warnings in the problem resolution panel of the DataFlex Studio you should add the IS$WEBAPP to the Tools | Configure Workspace | Conditionals | Workspace #IFDEF conditionals for your DataFlex Studio version 16.0 - 19.0 Windows GUI applications.

New cWebDRReportViewer class

The cWebDRReportViewer class is updated. Please make sure you check the ‘Copy APPHTML\DataFlex Reports Folder contents’ checkbox after attaching the new integration library in your web projects.

Important Information – Please Read Carefully

DataFlex CodeJock controls

DataFlex Reports uses the same version of the CodeJock components as DataFlex 18.0/18.1. If you uninstall DataFlex Reports you must manually run the ‘RegisterCodejockControls’ batch file in the DataFlex bin directory to ensure that DataFlex 18.0/18.1 will continue to run correctly.

Installation
DataFlex Reports 2017 – 6.1.5 is developed with DataFlex 18.2. If you do not have a version 18.2 Client License running on your PC, the setup will automatically install one for you.

DataFlex 16.x, 17.x, 18.x or 19.0 Studio license is required to use the Integration library which is part of DataFlex Reports 2017 Developer Edition.

DataFlex Reports 2017 – 6.1.5 cannot run side-by-side with version 6.1.x, you need to uninstall version 6.1.x before installing 6.1.5

To run your applications with version 6.1.5 you must detach the DataFlex Reports Integration library and attach the library installed with version 6.1.5.

Supported platforms

  • Microsoft Windows 10
  • Microsoft Windows 8 excluding RT
  • Microsoft Windows 7 Home Premium or higher
  • Microsoft Windows Server 2012 including R2
  • Microsoft Windows Server 2008 including R2
    • All of the above are supported in 32 and 64 bit editions
  • Windows Terminal Services when using Windows Server 2012 or Windows Server 2008
  • Citrix XenApp when used in conjunction with other supported Windows operating systems

Registration DataFlex Reports 6.1.5 will run as a 60-day trial version. If you start DataFlex Reports you will be asked to register your version. To register, you need to purchase a license. Registering will lift the trial period. After registering your license you have a 60 day period to activate your license. Make sure you have an internet connection, and simply confirm the activation.
Click here to learn where you can order your license.

Changes between 6.1.4 and 6.1.5

  • HDE 5197 https://support.dataaccess.com/Forums/showthread.php?60060-Re-New-Version
  • HDE 5140 https://support.dataaccess.com/Forums/showthread.php?61963-Text-Object-Problem
  • HDE 4847 Collapse all option for Report Explorer
  • HDE 4481 https://support.dataaccess.com/Forums/showthread.php?59345-DR-File-Path-in-the-statusbar-please
  • HDE 5180 Fixed problem with purged functions
  • HDE 5127 Undo button does not work with Pagelayers
  • HDE 4834 Implemented Alt+Up and Alt+Down for Report Explorer and Experts
  • HDE 4440 Save or Save as of a report with a .vrw extension will change extension to .dr
  • HDE 5129 https://support.dataaccess.com/Forums/showthread.php?61964-Another-Problem

Library:

  • HDE 5178 DRExportOptions.dg sets the filename to the correct extension
  • HDE 5196 Fixed problem in Wizard when using Windows integration
  • HDE 5131 Fixed problem when clicking in preview before report has run

Changes between 6.1.3 and 6.1.4

  • HDE 4683 Keep RDS sample data after changing RDS database
  • Allow RDS name to be changed
  • HDE 5103 Fixed problem with reports bases on SQL statement with string parameters
  • HDE 5075 Fixed problem with RDS alias names
  • HDE 5104 https://support.dataaccess.com/Forums/showthread.php?61754-Using-SQL-Statement-with-Parameters-as-Report-s-Datasource
  • HDE 3618 Added row number column in RDS sample data dialog
  • HDE 5079 Fixed problem with purge functions not working in Maintenance tool
  • HDE 5072 Fixed problem with Shift-Click not working in the Report Explorer
  • HDE 5084 Fixed Invalid message ‘OnExitObject’ when focus moves to Report Explorer while editing a text object
  • HDE 5082 https://support.dataaccess.com/Forums/showthread.php?61766-Report-crashes-when-filtering-subreport-on-text-field
  • HDE 4691 Added ability to remove the collating sequence in report, the F5 key now resets to default collate
  • HDE 5098 Fixed problem with default column in Insert Group dialog
  • HDE 5082 https://support.dataaccess.com/Forums/showthread.php?61766-Report-crashes-when-filtering-subreport-on-text-field
  • HDE 5109 Fixed ‘Referenced array index out of bounds’ error in Report/Field Explorer
  • HDE 5112 Top & bottom border of a subreport are not printed when Page header / footer are hidden in the subreport
  • HDE 5107 https://support.dataaccess.com/Forums/showthread.php?61897-DR-6-1-3-Sub-Sub-Report-Alignement
  • HDE 5046 https://support.dataaccess.com/Forums/showthread.php?61615-Pressing-F1-for-Help
  • HDE 4918 https://support.dataaccess.com/Forums/showthread.php?61128-DataFlex-reports-RC-II-function-editor-annoying-thing-with-SHIFT-TAB
  • HDE 4931 https://support.dataaccess.com/Forums/showthread.php?61203-Clicking-on-SubReport
  • HDE 4865 https://support.dataaccess.com/Forums/showthread.php?60944-Multiple-Object-Selection-in-Report-Explorer&highlight=report+explorer
  • Updated integration library
  • Updated help

Changes between 6.1 and 6.1.3

  • Fixed type conversion problem in SQL() function
  • Binary data can now be stored in RDS sample dialog
  • Fixed problem with saving functions when switching between functions in the function editor
  • HDE 5062 Increased maximum font size from 100 to 500 pts
  • HDE 5035 Empty functions are no longer automatically deleted
  • HDE 5042 Fixed problem with background color for barcodes
  • Updated integration library
  • Updated help

Changes between 6.0 and 6.1

  • Managed connection support (use the ODBC driver to use the new Managed Connections)
  • Added Russian language & collate
  • Added Hungarian language
  • Navigating in the report explorer now selects object in the design tab
  • Added Show Subreports option to Function Explorer
  • Added Find by Function ID option to Function Explorer
  • Added Import registration information to Registration dialog
  • Updated documentation

Bug fixes:

  • HDE 4914 https://support.dataaccess.com/Forums/showthread.php?61045-DR6-0-RC-Crashing-after-quot-Check-Database-quot
  • HDE 4950 Page layers only appear on first two pages
  • HDE 4937 ODBC memo fields have a default height/length of zero
  • HDE 4959 Validate Collate file name in designer
  • https://support.dataaccess.com/Forums/showthread.php?61208-Adding-Stored-Proc-to-report
  • HDE 4939 OEM/ANSI translate problem in Windows menu
  • HDE 4958 OEM/ANSI translate problem when switching language
  • HDE 4955 Studio shows wrong function when error occurs in a subreport
  • https://support.dataaccess.com/Forums/showthread.php?61269-Where-is-my-report-data-This-version-6-00-is-really-a-nightmare!
  • Group numbers are off by one after printing a subreport
  • Added message to find in Preview when string is not found
  • HDE 5002 Fixed problem with screens appearing gray
  • https://support.dataaccess.com/Forums/showthread.php?61387-Can-you-please-make-this-space-wider
  • https://support.dataaccess.com/Forums/showthread.php?61384-Variable-Height-Fields&highlight=variable+height
  • https://support.dataaccess.com/Forums/showthread.php?61437-Creating-Label-Reports-shows-ERROR
  • HDE 5010 Crash when printing barcode without data
  • Fixed problem with NVARCHAR(MAX) fields not displaying any data
  • Fixed problem with variable length fields (Memo and Binary) not working in Filter Function for the ODBC driver
  • Fixed error on first argument of the Propercase() function

Library:

  • https://support.dataaccess.com/Forums/showthread.php?61403-OnReportPreviewClick-is-not-firing-in-DF-19-00
  • Improved feedback when a function error occurs, including the possibility to copy the Function ID and the ability to find the Function ID in the DR Designer.
  • HDE 4969 https://support.dataaccess.com/Forums/showthread.php?61242-DR6-Reports-NOT-printing-anymore-URGENT-!!!

Changes between RC II and Release

  • Updated documentation
  • Added option to integrate the DataFlex Reports help into the DataFlex 19.0 Help system

Bug fixes:

  • HDE 4909 Incorrect summaries when used inside a group based on a function
  • HDE 4886/4922 https://support.dataaccess.com/Forums/showthread.php?61137-Dataflex-Reports-6-RC-2-Crashes-with-Sub-Report-in-Windows-10
  • HDE 4915 Group Sort Expert changes the sum to sort on when navigating through the groups
  • https://support.dataaccess.com/Forums/showthread.php?61126-DataFlex-Reports-RC-II-Select-Case
  • https://support.dataaccess.com/Forums/showthread.php?61102-psPreviewWaitingGif
  • Fixed ’Invalid cursor state’ error when using SQL() function
  • Fixed problem with incompatible data-types returned from SQL() function

Changes between RC and RC II

  • Updated documentation
  • PreviewWaitingGIF() property added
  • Added option to set the ‘Wrap state’ of existing reports to the Maintenace utility

Bug fixes:

  • HDE 4835/4857 SUM function output differs between report/page header and footer
  • Fixed problem in PDF export when white background color was used
  • 4839 Fixed problem with PDF export, the ‘End color’ is used even when ‘Gradient Type’ is set to ‘Solid’
  • Fixed problem with arrange objects always changing the distance of both X and Y axis
  • Fixed problem with CASE statement not working with some datatypes
  • Fixed error message during registration (MAC address error)
  • https://support.dataaccess.com/Forums/showthread.php?56773-Page-Numbering-Bug&p=322510#post322510
  • https://support.dataaccess.com/Forums/showthread.php?60880-Report-SQL-Query-not-showing-all-filters
  • Fixed problem with removing sub reports
  • HDE 4841 ‘Invalid bookmark value’ error when using ODBC and OEM character set
  • Fixed problem with ‘set datasource location’ dialog displaying subreports in wrong treeview branch
  • Fixed error message on right mouse-click in ‘Check Database’ dialog
  • Fixed problem with weird sort order when using AddSortField() from integration library
  • Fixed problem with Excel export skipping every other line
  • https://support.dataaccess.com/Forums/showthread.php?60941-Look-at-the-differences-between-5-0-1-amp-6-00-it-s-blurry-It-is-not-subtle-at-all&highlight=blurry
  • https://support.dataaccess.com/Forums/showthread.php?56773-Page-Numbering-Bug&highlight=reset+page+number
  • Fixed error message when closing main report with multiple opened subreports
  • HDE 4878 Cannot delete – unused – parameter
  • HDE 4806 Fixed problem with formatting when printing RTF text over multiple pages
  • Fixed memory overwrite
  • Improved comment support in function editor
  • https://support.dataaccess.com/Forums/showthread.php?61043-Reports-2017-RC-Error-108-symbol-File-field-not-defined

Library:

  • The cWebDRReportViewer class is updated.
  • Added support for DataFlex 19.0 tab-workspaces
  • cDRPreviewWindow class now sends PreviewPaint when a resize occurs (for tab-workspace support)
  • 18.0 library and higher; web.tpl (template) replaced with webPDF and webHTML templates
  • 19.0 library; icon and bitmap update

Changes between Beta II and Release Candidate

Bug fixes:

  • HDE 4752 https://support.dataaccess.com/Forums/showthread.php?60524-Arrange-Object-spacing-possible-YAFR
  • https://support.dataaccess.com/Forums/showthread.php?60693-DR6-0-Display-Status-Panel-flickering
  • https://support.dataaccess.com/Forums/showthread.php?60704-Text-field-Don-t-work-with-special-characters
  • Exporting reports with charts in HTML and PDF draws the chart upside down
  • Chart legend marker ‘width’ and ‘height’ values were swapped
  • Fixed Barcode error messages
  • Fixed ‘invalid data type’ errors in copy/paste of subreports
  • Fixed problem with adding existing report as a subreport changing tab names in the Studio
  • Fixed problem with PDF passwords no longer working
  • HDE 4686 Paint problem with current selection of combo box
  • HDE 4762 First row on every page of Excel export is empty when using ‘Data only’ export
  • HDE 4764 Error opening Excel 2007 export file
  • Fixed problem with varchar(max) fields in ODBC being converted to ‘string’ fields instead of ‘memo’ fields
  • Fixed problem with summaries on functions not working properly
  • One or more table mismatches’ error in check database when using tables from multiple schemas
  • Changing the label size did not change the size of the details section
  • Fixed errors hen using some of the Barcode constants (constants with dash symbols)
  • Images on RDS are now 1 inch by 1 inch by default if no image sample is available
  • Fixed problems with copying/pasting objects between reports based on different data sources
  • Fixed error messages when copying/pasting from the report explorer

Changes between Beta I and Beta II

  • JIT function pre-compiler
  • Added option for case-insensitive compare in functions. We recommend you turn this option on for all new reports (by default this option is turned on for new reports and off for existing reports).
  • -(null)’ values will no longer appear in RDS reports
  • Variable length Memo and Binary fields.
  • Anchor support
  • Helper for drawing Lines/Boxes over sections. You can create Lines and Boxes spanning multiple sections by inserting a Line/Box while holding the Ctrl key.
  • New ‘TableNameAlias’ function in OCX
  • Updated integration library

Bug fixes:

  • http://support.dataaccess.com/Forums/showthread.php?60036-DR-6-00-Barcode-Printing
  • HDE 4672 http://support.dataaccess.com/Forums/showthread.php?59388-quot-and-not-quot-not-working-anymore-DR-5-01
  • HDE 4673 remove and reorder table columns
  • HDE 4696 http://support.dataaccess.com/Forums/showthread.php?60073-DR6-slow!
  • HDE 4687 http://support.dataaccess.com/Forums/showthread.php?60080-Table-with-many-columns-produces-blank-output&highlight=lasso
  • http://support.dataaccess.com/Forums/showthread.php?57878-Subreport-in-Report
  • HDE 4724 Designer does not show italic fonts
  • HDE 4710 DR setup program installs the wrong DR.DB
  • HDE 4706 blank page after label report
  • HDE 4701 ’Referenced array index out of bounds’ error in designer
  • HDE 4700 Using section expert to change section height of label report
  • HDE 4698 Incorrect barcode colors used
  • HDE 4697 Barcode type constants are missing
  • HDE 4693 Unhandled program error when using extremely large fonts
  • HDE 4692/4694/4689 Unhandled program error when using spinforms with certain locale settings
  • HDE 4691 Export to HTML does not work with some images
  • HDE 4709 Export of barcode to PDF (high quality) does not work
  • HDE 4747 Invalid message error when aligning objects
  • Fixed error message for recursive functions

Changes between 5.0.1 and 6.0 Beta I

Implemented suggestions:

  • HDE 4612: Custom section names
  • HDE 4494: Extract page layer from report (see: http://support.dataaccess.com/Forums/showthread.php?59369-YAFR-Tool-to-extract-page-layer-back-to-DPL-file-from-DR-file)
  • HDE 4337/4203/3445: Add CASE statement to functions (see: http://support.dataaccess.com/Forums/showthread.php?58781-Wishlist-Case-statement&highlight=CASE)
  • HDE 4442: Select function in ‘Field Explorer’ after creation (see: http://support.dataaccess.com/Forums/showthread.php?59063-Suggestion-when-creating-a-new-function)
  • HDE 4637: Copy suppress condition using the ‘Same formatting’ option (see: http://support.dataaccess.com/Forums/showthread.php?59915-YAFR-If-it-doesn-t-exist)
  • HDE 3960: Ability to specify the default JOIN type in options
  • HDE 4580: Ability to copy fields between reports (see: http://support.dataaccess.com/Forums/showthread.php?52439-YAFR-Copy-amp-Paste-between-reports&highlight=copy+reports)
  • HDE 4660: Ability to get SQL statement for reports based on custom SQL (see: http://support.dataaccess.com/Forums/showthread.php?59001-Extracting-SQL-Statement-from-Report&p=310378#post310378)
  • HDE 1676: Support for Embedded SQL/SQL expression fields
  • HDE 4483: Open function editor on error
  • HDE 4661: Add function for ‘Group Sort Number’ option in the group expert
  • HDE 3985: Print multiple sections at bottom of page
  • HDE 4542: make Tables, Views and Stored procedures available when not selected in options (see: http://support.dataaccess.com/Forums/showthread.php?59468-Creating-new-report-in-Reports-5-0-don-t-show-my-stored-procedures&highlight=show+stored+procedures)
  • HDE 3389: Comment/Uncomment block in editor (see: http://support.dataaccess.com/Forums/showthread.php?52895-Few-Suggestions-amp-Bug-reports-for-next-release&highlight=comment)
  • 4665: Ability to change the canvas (background color) of a report from integration

Bug fixes:

  • HDE 4597/4466: ‘Size to font’ option clips data (see: http://support.dataaccess.com/Forums/showthread.php?59684-Possible-bug-Size-To-Font)
  • 4622: Default height of textbox differs from database fields
  • 4596: Different default function widths when inserting from menu (see: http://support.dataaccess.com/Forums/showthread.php?59698-Numeric-function-width-when-inserting-from-the-Menu)
  • HDE 4432: Function return type incorrect when calling another function (see: http://support.dataaccess.com/Forums/showthread.php?58996-Isn-t-it-time-that-the-functions-return-type-get-evaluated-correctly)
  • HDE 3166: Bug in ‘Database Expert’ (see: http://support.dataaccess.com/Forums/showthread.php?52071-Database-expert-bug&highlight=database+expert)
  • HDE 4578: Refresh of ‘Field Explorer’ jumps to wrong item after dragging a field
  • HDE 4599/4496: Page layers do not respect ‘Word wrap’ option (see: http://support.dataaccess.com/Forums/showthread.php?59699-BUG-Page-Layer-File-not-respecting-quot-Word-Wrap-quot)
  • HDE 4428: DR exits when using ‘Align to baseline’ on a text object and a line (see: http://support.dataaccess.com/Forums/showthread.php?58951-Small-bug)
  • HDE 4486: ‘Referenced Array Index Out of Bounds’ error when dragging a field while holding the Ctrl key
  • HDE 4550: Wrong icon for ‘Refresh’ in Report menu
  • HDE 4584: ‘Illegal datatype conversion’ error when using ‘Redo’ option in a subreport
  • HDE 4552: Delete row from sample RDS data does not work
  • HDE 4662: ‘Variable height’ field is missing the last line (see: http://support.dataaccess.com/Forums/showthread.php?59784-BUG-Print-of-a-variable-length-field-is-missing-last-line)
  • HDE 4663: Group sort within a normal group does not work
  • HDE 4664: Alias names are not updated when using the ‘Change Datasource Wizard’ to convert a report from RDS to RDS
  • HDE 4643: ‘Table XXX has no column named XXX’ error when the column does exist
  • HDE 4370: Reserved words in RDS column names (see: http://support.dataaccess.com/Forums/showthread.php?58497-Baffled!!-RDS-Prblem-HELP!)
  • HDE 4667: Report options dialog shows the wrong label sizes

Library:

  • HDE 4403: Replaced DownloadURL call in ExportReportToDownloadURL with CustomDownloadURL
  • HDE 4439: Implemented suggestion to add file extension to export filename if not specified in DRExportOptions.dg
  • HDE 4427: Repaint of preview after PreviewFind
  • HDE 4636: pbServerOnEscape set to true in DRPDFModalDialog.wo
  • HDE 4665: Added new method to set the color of the preview canvas
  • Moved the code previously generated by the wizard for the OnProgressRecordsRead and OnProgressFormatPage methods to the cDRReport class
  • Added new preview option for windows implemented in class cDRDesktopPreview
  • Excluded all methods unavailable in web applications in cDRReport with conditional compiler switch
  • Moved all methods and properties from cWebDRReport to cDRReport, the cWebDRReport is now an empty class and the wizard will generate a cDRReport

Wizard Changes

  • Added new preview option – DesktopView – similar to the tool-panel but with additional button in the windows task bar
  • OnProgressRecordsRead and OnProgressFormatPage methods are no longer generated


What is New in version 6.0?

Barcode support

DataFlex Reports 6.0 supports over 70 different types of symbologies (type of barcodes) both one-dimensional 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.

 


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.


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.

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 data-sources and is a powerful addition to report developers. However, only a single value can be returned from a SQL() function.

Suggestions and bug fixes

DataFlex Reports 6.0 includes over 30 implemented user suggestions and bug-fixes. See the ‘Changes’ section in this readme for a complete list.

Existing DataFlex Reports 4.x user information

All classes, constants and files in the DataFlex Reports integration – included in this version – have been renamed as part of the rebranding of the DataFlex Reports product. For existing pre-DataFlex Reports 4.0 applications create a backup of your existing project(s) and take the following steps to update to the 6.1.5 library:

Remove the existing DataFlex Reports library and add the DataFlex Reports 6.1.5 library to your workspace (this may require you to start the DataFlex Studio with administrator rights).

  1. Click the replace in files button in the Studio (Ctrl+Shift+H)
    1. Enter VRW in the “Text to Find” input field
    2. Enter DR in the “Text to Replace” input field
    3. Click the “Replace All” button
  2. Open the <projectname>.cfg file
    1. Replace all VRW with DR for the icons and bitmaps
  3. Search for the usage of psDatabaseCollate and remove the code. The property does not exist anymore
  4. Windows projects
    1. Replace all occurrences of “cCJSortColumnsGrid” with “cDRSortColumnsGrid”
    2. Replace all occurrences of “cCJSortDirectionsGridColumn” with “cDRSortDirectionsGridColumn”
  5. Web Application Framework projects
    1. Replace all occurrences of “oPDFModalDialog” with “oDRPDFModalDialog”
    2. Replace all occurrences of “Use PDFModalDialog.wo” with “Use DRPDFModalDialog.wo”
  6. Optional:
    1. Replace all “.vrw” to “.dr” in the program code
    2. Rename all reports with a VRW extension to DR

Language support

DataFlex Reports ships with support for a number of languages. Before changing the language used in DataFlex Reports you must set your Windows Regional Options to the language of your choice. This ensures that the correct (ANSI) code page is selected in Windows. You can change the Regional Options in the Windows Control Panel, for full language support you must change both the ‘Standards and formats’ option to ensure correct date and number handling and the ‘Language for non-unicode programs’ option. Please note that the name of these options may differ in various versions of Windows. After changing the Windows Regional Options you can change the language in DataFlex Reports by choosing a language from the ‘Language’ menu.

Integration library

DataFlex Reports comes with an Integration library. This library allows you to seamlessly integrate reports with your DataFlex 16.x, 17.x, 18.x or 19.0 applications. The library contains an Integration Wizard and classes for integrating and viewing reports. During installation you can specify the location of the Integration library. We suggest you install the library in a subfolder of the main DataFlex directory, this allows you to add the library using relative paths. To use the Integration library and Integration Wizard in your DataFlex projects and Workspaces you must first add the library. You can do this by opening the DataFlex Studio and select the ‘Maintain Libraries…’ option from the ‘Tools’ menu. Next, you can use the ‘Add Library’ button and open the ‘DataFlex Reports XXX.sws’ file. After selecting the .sws file and clicking the ‘Ok’ button a wizard will be started which will guide you through the process of adding the library to the currently selected workspace.
For windows application, simply choose the ‘View/Report’ option from the ‘File’ menu and select the ‘DataFlex Reports Wizard’ icon. For Web applications use the ‘Web Object’ option from the ‘File’ menu.

Reporting bugs, comments and suggestions

Please report bugs to support@dataaccess.eu, if you have a HelpDesk Express account you can also enter reports directly at http://hde.dataaccess.eu. Make sure to provide as much detail as possible to define and reproduce the problem that you are reporting. Upon your report, you will be invited to use an account on our help-desk support system for reporting future issues. For further communications and information, there is a forum devoted to DataFlex Reports in the Data Access Worldwide Support Forums.

 

What is New in version 6.0?

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.

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.

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.

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.

Important Information – Please Read Carefully

Existing reports

The .dr (or .vrw for older reports) report definition format has changed between version 4.x and 5.x. If you save reports with this version of DataFlex Reports, you can no longer use them in previous versions.

Special caution with regard to this: when opening reports made with an older version it is advised to run the ‘check database’ option.

Existing workspaces with integrated reports

If you have an existing DataFlex Reports 5.0 Beta I web project you should detach the old integration library and re-attach the library. This ensures that the JavaScript and CSS files are copied from the library to your workspace.

DataFlex CodeJock controls

DataFlex Reports uses the same version of the CodeJock components as DataFlex 18.2. If you uninstall DataFlex Reports you must manually run the ‘RegisterCodejockControls’ batch file in the DataFlex bin directory to ensure DataFlex 18.2 will continue to run correctly.

Installation
DataFlex Reports 2016 – 5.0.1 is developed with DataFlex 18.2. If you do not have a version 18.2 Client License running on your PC, the setup will automatically install one for you.

DataFlex 16.0/16.1, 17.0/17.1 or 18.0/18.1/18.2 Studio license is required to use the Integration library which is part of DataFlex Reports 2016 Developer Edition.

Supported platforms

  • Microsoft Windows 10
  • Microsoft Windows 8 excluding RT
  • Microsoft Windows 7 Home Premium or higher
  • Microsoft Windows Server 2012 including R2
  • Microsoft Windows Server 2008 including R2
    • All of the above are supported in 32 and 64 bit editions
  • Windows Terminal Services when using Windows Server 2012 or Windows Server 2008
  • Citrix XenApp when used in conjunction with other supported Windows operating systems

Registration DataFlex Reports 5.0.1 will run as a 60-day trial version. If you start DataFlex Reports you will be asked to register your version. To register, you need to purchase a license. Registering will lift the trial period. After registering your license you have a 60 day period to activate your license. Make sure you have an internet connection, and simply confirm the activation.

Changes between 5.0 and 5.01

Bug fixes:

  • Performance improvements for summaries - both summary fields and Sum() functions (see: http://support.dataaccess.com/Forums/showthread.php?58639-Enter-summary-s-exit-speed&highlight=summaries)
  • Fixed problem with schema list not always showing all schemas (see: http://support.dataaccess.com/Forums/showthread.php?58991-DataFlex-Report-Writer-5-0-Data-Source-problem&highlight=schema)
  • Fixed problem with Epson printer (see: http://support.dataaccess.com/Forums/showthread.php?59007-S-O-S-Epson-LX&highlight=Epson)
  • Fixed table size/position not remembered in database expert (see: http://support.dataaccess.com/Forums/showthread.php?59080-DR5-Database-Expert-Table-Links-weird-behaviour&highlight=database+expert)
  • Fixed problem with fonts not being embedded in PDF export (see: http://support.dataaccess.com/Forums/showthread.php?59072-Barcode-printing-Free3of9&highlight=PDF+export)
  • Fixed problem where only the first two expressions of a filter function are used for offloading (see: http://support.dataaccess.com/Forums/showthread.php?59141-DR5-Report-Filters-Pain&highlight=filter)
  • Fixed rare problem where sections did not always appear in preview (see: http://support.dataaccess.com/Forums/showthread.php?59139-Missing-Records-Revisited!&highlight=margin)
  • Fixed problem with CodeDescription (CodeMast) ELF not working when used with .INT files (see: http://support.dataaccess.com/Forums/showthread.php?56381-DR4-02-Can-t-open-Codemast-table&highlight=codemast)
  • Fixed problem with embedded images (see: http://support.dataaccess.com/Forums/showthread.php?59071-Hitting-some-memory-limit-amp-crashing-during-report-design)
  • Fixed typo and casing of build-in function names in the function editor
  • Fixed problem in field properties where the image location was not being saved after using the prompt button to select an image
  • Clicking the ‘Cancel’ button on the SQL statement dialog no longer clears the statement
  • Fixed memory leaks
  • Tables without an alias name retain their existing (alias) name when using the ‘Change Datasource’ wizard

Library:

  • cDRReportHelper.pkg
    • New package cDRReportHelper.pkg. This file contains the cDRReportHelper class containing the DateTimeToString, DateToString and TimeToString functions. In version 5.0 and older these functions were part of the cDRReport class. They are still there for backwards compatibility but redirect to the functions in an automatically created child object named oDRReportHelper. This way the functions can be used in DataFlex components that don’t contain a cDRReport object. The integration wizard generates an object of the cDRReportHelper class in components that don’t need a cDRReport object
  • DRExportOptions.dg
    • PDFType combo added to the oDRExportOptionsDialog object (in DRExportOptions.dg)
  • cDRReport.pkg
    • When using preview to a MDI view (cDRPreview) or a toolpanel (cDRToolPanelPreview) the results were not refreshed if the preview window wasn’t closed before changing selection criteria and executing the report again

Wizard Changes:

  • The wizard now supports reports not using a filelist as database but individual tables
  • When using an ODBC report the wizard checks if the tablenames used matches the data-dictionaries defined in the workspace and generates DDO’s and code to use these
  • The wizard now sets piColumnCount for the SortOrderGroup in a web component

Changes between Release Candidate and Release

Bug fixes:

  • Increased the maximum image size in RDS tables
  • Fixed problem with size of docking panes in RDS sample dialog
  • Fixed problem with explorers not always working

Changes between Beta II and Release Candidate

Bug fixes:

  • Information message if the selected printer bin is not supported by the printer
  • Fixed problem with ‘Hide section’ not working
  • Stored procedures did not appear in the list when using an ODBC datasource
  • Background color of boxes do not show in the designer
  • Fixed problems with explorer panes appearing in the top-left corner
  • Function name’ combo was not initialized in the ‘Library function’ (ELF) dialog
  • Current connection in Database Expert did not show schemas for ODBC connection
  • Varchar(max) fields did not show any data when running the report
  • Left & Right arrow keys did not work when field was (partially) outside the page borders
  • Fixed problems with field masks not working

Changes between Beta I and Beta II

New features:

  • Support for PDF/A export. When creating a PDF/A the following options are prohibited and an error message is generated if the report contains any of the following:
    • Alpha channels (transparency) – for example an image with transparency or a gradient
    • Passwords (both user and owner passwords)
    • An image with an unsupported – embedded – ICC profile
  • ‘Wrap text’ option added to the field properties. If this option is not set the object is always formatted in a single line. With this option set the text will wrap and as many lines as can fit in the object rectangle are displayed.

Bug fixes:

  • Numerous fixes in the Integration library wizards and JavaScript/CSS files
  • Fixed problem with ‘overlay next section’ (HDE 4317)
  • Using the ‘Cancel’ button in the ‘SQL Statement’ generated an ‘invalid argument value’ error (HDE 4307)
  • Double click on ‘SQL Statement’ treeview item in the ‘Database expert’ did not start the dialog (HDE 4306)
  • Adding a field to a label report using the ‘Field explorer’ would add a Field Heading label - if the option was selected (HDE 4299)
  • The ‘Section Expert’/’Report Explorer’ and other dialogs included all sections for label reports – however a label report only has a details section (HDE 4300)
  • ‘Array index out of bounds’ error when creating a label report using the wizard without selecting any fields for the report (HDE 4298)
  • A sub-report inside a – blank - section with the option ‘Hide blank section’ set would not show the sub-report (HDE 4296)
  • Fields in the details section of a sub-report created with the wizard would be placed on top of each other (HDE 4294)
  • Field Heading labels would not be included when creating sub-reports using the wizard – even if the option was selected (HDE 4295)
  • ‘Stack overflow’ error when running a report with summaries on large number of records (HDE 4277)
  • A groupname based on a function does not display contents (HDE 4162)
  • Rename of a function using the field explorer can duplicate the function name (HDE 4095)
  • Export to PDF and RTF of a box with the border set to ‘none’ does displays box borders (HDE 4089)
  • Alignment does not work when one of the objects is locked – using the ‘Allow move/resize of locked fields via keyboard’ option enables alignment of locked objects (HDE 3890)
  • Bottom pixel was clipped when export to PDF – low quality (HDE 3284)
  • 0.5 point lines and boxes did not appear in HTML export, other non integer line thickness would be rounded down to nearest integer (HDE 3284)
  • Horizontal/Vertical position and Width/Height fields in the ‘Field properties’ dialog are incorrectly rounded down.
  • Mask fields are incorrectly initialized in the ‘Field properties’ dialog when using a Custom number or Currency mask

Changes between Alpha and Beta I

New features:

  • Support for mobile devices has been added to the integration
  • DataFlex 18.2 integration library added
  • New chart types (Pie and Pyramid) are now available (see what is new in version 5.0)
  • Redesigned keyboard interface and new keyboard interface for moving and resizing to a guideline(see what is new in version 5.0)
  • Paper margins can now be changed from integration(see what is new in version 5.0)
  • New option ‘Allow move/resize of locked fields via keyboard’ added (see what is new in version 5.0)

Bug fixes:

  • Fixed error when deleting all horizontal guidelines
  • Fixed problem with Undo not working correctly
  • Fixed problems with moving horizontal guidelines
  • Moving guidelines now checks for negative size/position of objects
  • Fixed problem with RDS sample data dialog not showing first sample record (HDE 4237)
  • When printing all pages the selected tray is not respected if no tray was selected in the report
  • Fixed error when editing a function from the Field Explorer; after changing the name of the function an error 98 was triggered (HDE 4262)
  • When printing a report the background color of a section was printed in the wrong position - export and preview worked correctly (HDE 4260)

What is New in version 5.0?

Labels

The new report wizard now has an extra option, to create multi-column label reports. It lets you define the correct format that can be stored in the repository for later use. Existing label reports can be easily changed via the Label tab in the Report Options.

SQL Statement

You can now directly enter a SQL statement – including parameters - for your ODBC reports. A parameter field will be automatically added to your report for every parameter you include in the SQL statement.

New chart types

Two new chart types have been added; Pie and Pyramid.

Print section over multiple pages

A new section option to allow sections to span multiple pages had been added to the section expert.

Redesigned keyboard interface

Moving and resizing objects using the keyboard has been redesigned to allow more intuitive use of the keyboard. New keyboard support for moving to a guideline (Alt+Arrow keys) and resizing to a guideline (Alt+Shift+Arrow keys) has been added.

Miscellaneous

ODBC Tables/Views etc. are now divided into schemas.
Paper margins can now be changed from integration.
New options:

  • Option to save a report on preview.
  • Option to allow moving and resizing of locked fields via keyboard.

New section options:

  • Option to overlay next section.
  • Option to exclude a page footer section from the start of page footer.

New field options:

  • Option to change the vertical alignment.

Report options:

  • Option to print a report on alternate pages.

Existing DataFlex Reports user information

All classes, constants and files in the DataFlex Reports integration – included in this version – have been renamed as part of the rebranding of the DataFlex Reports product. For existing pre-DataFlex Reports 4.0 applications create a backup of your existing project(s) and take the following steps to update to the 5.x library:

Remove the existing DataFlex Reports library and add the DataFlex Reports 5.x library to your workspace (this may require you to start the DataFlex Studio with administrator rights).

  1. Click the replace in files button in the Studio (Ctrl+Shift+H)
    1. Enter VRW in the “Text to Find” input field
    2. Enter DR in the “Text to Replace” input field
    3. Click the “Replace All” button
  2. Open the <projectname>.cfg file
    1. Replace all VRW with DR for the icons and bitmaps
  3. Search for the usage of psDatabaseCollate and remove the code. The property does not exist anymore
  4. Windows projects
    1. Replace all occurrences of “cCJSortColumnsGrid” with “cDRSortColumnsGrid”
    2. Replace all occurrences of “cCJSortDirectionsGridColumn” with “cDRSortDirectionsGridColumn”
  5. Web Application Framework projects
    1. Replace all occurrences of “oPDFModalDialog” with “oDRPDFModalDialog”
    2. Replace all occurrences of “Use PDFModalDialog.wo” with “Use DRPDFModalDialog.wo”
  6. Optional:
    1. Replace all “.vrw” to “.dr” in the program code
    2. Rename all reports with a VRW extension to DR

Language support

DataFlex Reports ships with support for a number of languages. Before changing the language used in DataFlex Reports you must set your Windows Regional Options to the language of your choice. This ensures that the correct (ANSI) code page is selected in Windows. You can change the Regional Options in the Windows Control Panel, for full language support you must change both the ‘Standards and formats’ option to ensure correct date and number handling and the ‘Language for non-unicode programs’ option. Please note that the name of these options may differ in various versions of Windows. After changing the Windows Regional Options you can change the language in DataFlex Reports by choosing a language from the ‘Language’ menu.

Integration library

DataFlex Reports comes with an Integration library. This library allows you to seamlessly integrate reports with your DataFlex 16.0/16.1, 17.0/17.1 or 18.0/18.1/18.2 applications. The library contains an Integration Wizard and classes for integrating and viewing reports. During installation you can specify the location of the Integration library. We suggest you install the library in a subfolder of the main DataFlex directory, this allows you to add the library using relative paths. To use the Integration library and Integration Wizard in your DataFlex projects and Workspaces you must first add the library. You can do this by opening the DataFlex Studio and select the ‘Maintain Libraries…’ option from the ‘Tools’ menu. Next, you can use the ‘Add Library’ button and open the ‘DataFlex Reports XXX.sws’ file. After selecting the .sws file and clicking the ‘Ok’ button a wizard will be started which will guide you through the process of adding the library to the currently selected workspace.
For windows application, simply choose the ‘View/Report’ option from the ‘File’ menu and select the ‘DataFlex Reports Wizard’ icon. For Web applications use the ‘Web Object’ option from the ‘File’ menu.

Reporting bugs, comments and suggestions

Please report bugs to support@dataaccess.eu, if you have a HelpDesk Express account you can also enter reports directly at http://hde.dataaccess.eu. Make sure to provide as much detail as possible to define and reproduce the problem that you are reporting. Upon your report, you will be invited to use an account on our help-desk support system for reporting future issues. For further communications and information, there is a forum devoted to DataFlex Reports in the Data Access Worldwide Support Forums.

Before installing the DataFlex Reports 4.0.2 update, please uninstall your existing DataFlex Reports 4.x Developer Edition. If the setup program detects a DataFlex Reports 4.x installation, the setup will be aborted.

Important Information – Please Read Carefully

All classes, constants and files in the DataFlex Reports integration – included in this update – have been renamed as part of the rebranding of the DataFlex Reports product. For existing DataFlex Reports 3.0 applications create a backup of your existing project(s) and take the following steps to update to the 4.0.2 library:

Remove the existing DataFlex Reports library and add the DataFlex Reports 4.0.2 library to your workspace (this may require you to start the DataFlex Studio with administrator rights).

  1. Click the replace in files button in the Studio (Ctrl+Shift+H)
    1. Enter VRW in the “Text to Find” input field
    2. Enter DR in the “Text to Replace” input field
    3. Click the “Replace All” button
  2. Open the <projectname>.cfg file
    1. Replace all VRW with DR for the icons and bitmaps
  3. Search for the usage of psDatabaseCollate and remove the code. The property does not exist anymore
  4. Windows projects
    1. Replace all occurrences of “cCJSortColumnsGrid” with “cDRSortColumnsGrid”
    2. Replace all occurrences of “cCJSortDirectionsGridColumn” with “cDRSortDirectionsGridColumn”
  5. Web Application Framework projects
    1. Replace all occurrences of “oPDFModalDialog” with “oDRPDFModalDialog”
    2. Replace all occurrences of “Use PDFModalDialog.wo” with “Use DRPDFModalDialog.wo”
  6. Optional:
    1. Replace all “.vrw” to “.dr” in the program code
    2. Rename all reports with a VRW extension to DR

Existing reports

The .dr (or .vrw for existing reports) report definition format has changed between version 3.0 and 4.0.
Special caution with regard to this: when opening reports made with an older version it is advised to run the ‘check database’ option.

DataFlex CodeJock controls

DataFlex Reports uses the same version of the CodeJock components as DataFlex 18.0. If you uninstall DataFlex Reports you must manually run the ‘RegisterCodejockControls’ batch file in the DataFlex bin directory to ensure DataFlex 18.0 will continue to run correctly.

Installation
DataFlex Reports 2014 – 4.0.2 is developed with DataFlex 18.0. If you do not have a version 18.0 Client License running on your PC, the setup will automatically install one for you.
A DataFlex 16.0/16.1, 17.0/17.1 or 18.0/18.1 Studio license is required to use the Integration library which is part of DataFlex Reports 2014 Developer Edition.

Supported platforms

  • Microsoft Windows 8 excluding RT (32/64 bit)
  • Microsoft Windows 7 Home Premium or higher (32/64 bit)
  • Microsoft Windows Server 2012
  • Microsoft Windows Server 2008 R2 (32/64 bit)
  • Microsoft Windows Vista SP2 Home Premium or higher (32/64 bit)
  • Microsoft Windows XP SP3 (32 bit)
  • Windows Terminal Services when using Windows Server 2012 or Windows Server 2008
  • Citrix XenApp when used in conjunction with other supported Windows operating systems

Registration

DataFlex Reports will run as a 60-day trial version by default. If you start DataFlex Reports you will be asked to register your version. To register, you need to purchase a license. Registering will lift the trial period. After registering your license you have a 60 day period to activate your license. Make sure to have an internet connection, and simply confirm the activation.

Changes between 4.0.1 and 4.0.2

  • HDE 4023: ‘Report appears to be damaged’ error when using ‘return 0’ in a filter function
  • HDE 4069: RDS datatypes are automatically converted to DateTime
  • HDE 3187: Round() function does not support ‘commercial’ rounding (like used in DF)
  • HDE 4018: No error message is triggered from Integration library when function contains error(s)
  • HDE 4022: Margins are shifted to the right when printing to printer
  • HDE 4007: TestFilterFunction in Integration library always returns TRUE
  • HDE 4006: Paint problem in Integration library when opening a report
  • HDE 4076: Black background when printing to some printers
  • HDE 4077: Position of page footer(s) is wrong when both the ‘hide this section’ checkbox and the ‘hide this section’ function are used
  • HDE 4078: Output is not clipped to page margins when printing to printer or exporting a report
  • HDE 4079: Database expert shows empty RDS entries

What is New in version 4.0?

Charts

DataFlex Reports 4.0 includes support for creating Charts. In the 4.0 release Area, Bar, Line and Point chart types will be available; more Chart types will follow in future versions.

Function Explorer

The new Function Explorer is a quick and convenient way to browse through all the functions defined in your reports. Both user defined and built-in functions can be queried.

RTF Export

Version 4.0 of DataFlex Reports adds support for RTF Export. The RTF (Rich Text Format) export is based on the Microsoft Word 2007 specifications.

Page Layers

In version 4.0 you can create new page layers and add them to your report(s). A report can contain any number of page layers that are embedded in the report, eliminating the need to deploy the page layers separately.

Images

Images stored in databases (both DataFlex and ODBC) can now be used directly in DataFlex Reports. Also new is the image display option which will display an image Filled, Fitted or in the Original size within the design rectangle.

Collate

New collating files are included with DataFlex Reports version 4.0 that allow sorting based on character weight and include the code page for which the collate was created. The collate is saved in the report ensuring the same sort order with deployed reports.

Function Editor

The Function Editor included with DataFlex Reports now includes a list of all the global variables defined in the report and adds a number of new functions as well as a number of extended functions.

Miscellaneous

Other changes in version 4.0 include a font strikeout option, a new RDS sample dialog and an option to prompt for RDS data each time you preview the report, improved error reporting, the ability to add summaries in report and group headers and improved remote desktop support.

Language support

DataFlex Reports ships with support for a number of languages. Before changing the language used in DataFlex Reports you must set your Windows Regional Options to the language of your choice. This ensures that the correct (ANSI) code page is selected in Windows. You can change the Regional Options in the Windows Control Panel, for full language support you must change both the ‘Standards and formats’ option to ensure correct date and number handling and the ‘Language for non-unicode programs’ option. Please note that the name of these options may differ in various versions of Windows. After changing the Windows Regional Options you can change the language in DataFlex Reports by choosing a language from the ‘Language’ menu.

Integration library

DataFlex Reports comes with an Integration library. This library allows you to seamlessly integrate reports with your DataFlex 16.0/16.1, 17.0/17.1 or 18.0 applications. The library contains an Integration Wizard and classes for integrating and viewing reports. During installation you can specify the location of the Integration library. We suggest you install the library in a subfolder of the main DataFlex directory, this allows you to add the library using relative paths. To use the Integration library and Integration Wizard in your DataFlex projects and Workspaces you must first add the library. You can do this by opening the DataFlex Studio and select the ‘Maintain Libraries…’ option from the ‘Tools’ menu. Next, you can use the ‘Add Library’ button and open the ‘DataFlex Reports XXX.sws’ file. After selecting the .sws file and clicking the ‘Ok’ button a wizard will be started which will guide you through the process of adding the library to the currently selected workspace.
For windows application, simply choose the ‘View/Report’ option from the ‘File’ menu and select the ‘DataFlex Reports Wizard’ icon. For Web applications use the ‘Web Object’ option from the ‘File’ menu.

 

Reporting bugs, comments and suggestions

Please report bugs to support@dataaccess.eu, if you have a HelpDesk Express account you can also enter reports directly at http://hde.dataaccess.eu. Make sure to provide as much detail as possible to define and reproduce the problem that you are reporting.

Upon your report, you will be invited to use an account on our help-desk support system for reporting future issues.

For further communications and information, there is a forum devoted to DataFlex Reports in the Data Access Worldwide Support Forums.

 

Beta

Download pre-releases of DataFlex Reports 

Pre-releases

This is the release candidate for DataFlex Reports 2022 version 8.1. Compared to the second beta the following improvements and fixes can be found in this update:

New Features

  • The DSN less connection configuration page in the ODBC database connection page has been altered. The database name can now be entered manually. When the database driver does not require selecting a database it can be omitted. There is an extra input field for connection string attributes which might be used for a specific connection
  • Crosstable now reports an error when the minimum output does not fit on a page 
  • Update If feature in maintenance utility now processes sub-reports

Bugfixes

  • Stored procedures parameter support has been improved
  • RTF export issue with numbers has been fixed
  • Crash on sub-reports using variable length fields has been fixed
  • Where clause in SQL select statement no longer uses double quotes when the value contains a single quote
  • Double integer export to Excel has been fixed
  • Chr() function can now be used to print unicode characters
  • Finding deleted columns in check database dialog is now possible
  • Improved keyboard navigation in Studio’s menus
  • ODBC datasource selection painting issue addressed
  • ComReportInfo function missed groups when group headers were repeated on the next page, fixed
  • Crosstab values sometimes did not appear, fixed
  • Text object lost leading spaces on saving report definition
  • Fixed the problem that an SQL statement based report could not be altered
  • CSS change for HTML previewer fixes
  • CSV export options for field and value delimiter were reversed
  • BOM character in DrExportOptions.dg for DataFlex 19.1 removed
  • Help files updates. Help file now contains the DR logo in the title bar to avoid confusion with other help files

This is the second beta for DataFlex Reports 2022 version 8.1. Compared to the first beta the following improvements and fixes can be found in this update:

New Features

  • Maintenance utility has been extended with a "if" test. This helps finding and fixing functions that would otherwise run into a syntax error on an Else If statement. See for more inormation the readme and the help file

Bugfixes

  • Support for AltGr (specific AZERTY) keyboards added to the function editor
  • Better explanation and warning for the changes in the function syntax regarding to Else If. If you save a v7 or older report in v8.1 you now get a warning that you should check the syntax changes on Else If in the functions
  • RDS test data not longer trimmed
  • Fix for RDS (memo) columns with an invalid length value
  • The data-source "Runtime DataSource" gets translated into your selected language. This caused problems when adding a new Runtime DataSource table
  • Fix for invalid metrics names in the section expert
  • Regional settings set to Hungarian let the default options dialog not show the default formatting for dates and numbers
  • Search in field explorer could cause an unwanted error
  • Invalid data in browse data dialog on date columns
  • Large integer constant value used in filter function caused report to not show results
  • Some messages where not translated
  • The installer now installs the language.db in the DR 32 Bits folder
  • Help files updates

This is the first beta for DataFlex Reports 2022 version 8.1. The following improvements and fixes can be found in this update:

Main new features

  • Support for more than one database at the same server accessible via the same database connection. The feature is limited to Microsoft SQL Server. If you have tables from two or more databases you can now connect them in one report.
  • When linking two tables it is no longer required - while still highly recommended - that the columns used in the link are based on the same data type and/or length.
  • The floating tool-bar in the Web Report Viewer for HTML and IMAGEs now contains a button for exporting the report results to another format. Another format such as PDF, Excel etc
  • To change the name of the database in a multi database report a new property named psTableCatalog has been added
  • The current page item in a Windows previewer now support both a spinform or a drop-down with page numbers controlled by a new property piPageMaxCombo
  • New HTML previewer (OnPreHTMLPreviewData and OnPostHTMLPreviewData) events added to the cDRReport’s GenerateReportHTML method. Useful when you want to log the used SQL query by the report engine
  • RTF data was printed as raw RTF in an HTML output. The new feature solves this which makes it possible to use Windows style formatted text in a HTML environment

Bugfixes

  • Unary operator not allowed on operand
  • Invalid number of columns in an RDS datasource shown as garbage data in the error
  • Grouptree icons were not added to the <project>.cfg when using the integration wizard
  • Incorrectly added linefeed to the source code when DataFlex Studio is configured to save source code as OEM instead of UTF-8
  • Charts in a sub-report were not displayed
  • RDS Memo style column was incorrectly sized by the new report wizard
  • Keep group together now prints part of the group on page 1 when it does not fully fit there, It used to move to the next page
  • Using help in the DataFlex Reports Studio caused a GPF when invoked from dialogs due to a missing window name in the help file itself
  • Resize chart in previewer crashed the engine
  • RTF data sometimes formatted differently when exporting to PDF
  • Summary on next page with wrong header data fixed
  • RDS table name change was not properly broadcasted to functions
  • A Web HTML report “randomly” contained garbage data. Only with a 32 bit webapp
  • Number to large to convert to integer. When the value was above 10 digits but within the integer range it resulted in this error
  • Zoom factor comboform in preview wasn’t always showing the right value
  • Invalid Window Handle error in previewer of the integrate reports wizard fixed

 

This is the second release of the Technology Preview version for DataFlex Reports 2020 (v8.0). 

DataFlex  Reports Studio is now a 64 bit application using a 64 bit OCX and fully  Unicode capable. With the Unicode capabilities of the product one can  use, print and export Unicode based characters without ANSI codepage  dependencies

For report integration in applications a  64 bit and a 32 bit OCX are available. Use the latter one to enable  Unicode support in 32 bit applications. Note that the 64 bit version  better utilize the capabilities of the computer (e.g. more memory).

Report integration is supported with DataFlex 19.0, 19.1 and 20.0.

DataFlex  Reports Studio 2020 is written with DataFlex 2020 Alpha I. When the  DataFlex Reports 2020 installer does not detect a DataFlex Studio 2020  as being installed it will install a DataFlex Client 2020 to run with.  If you later want to install the DataFlex Studio 2020 on the machine go  to "Add and Remove programs" and uninstall the DataFlex 2020 Client  software. 

This is the first release of the Technology Preview version for DataFlex Reports 2020 (v8.0). 

DataFlex Reports Studio is now a 64 bit application using a 64 bit OCX and fully Unicode capable. With the Unicode capabilities of the product one can use, print and export Unicode based characters without ANSI codepage dependencies

For report integration in applications a 64 bit and a 32 bit OCX are available. Use the latter one to enable Unicode support in 32 bit applications. Note that the 64 bit version better utilize the capabilities of the computer (e.g. more memory).

Report integration is supported with DataFlex 19.0, 19.1 and 20.0.

DataFlex Reports Studio 2020 is written with DataFlex 2020 Alpha I. When the DataFlex Reports 2020 installer does not detect a DataFlex Studio 2020 as being installed it will install a DataFlex Client 2020 to run with. If you later want to install the DataFlex Studio 2020 on the machine go to "Add and Remove programs" and uninstall the DataFlex 2020 Client software. 

This version of DataFlex Reports uses a v7.0 license code or runs for 60 days in evaluation mode. DataFlex Report license holders receive the license code short after the final release via their sales representative.

DataFlex Reports v7 runs side-by-side with older versions. Note that saving the report definition file (.dr) with v7 makes it not accessible with v6.2 or older anymore.

New Installer

DataFlex Reports uses the new modern product installer. The layout is restyled, it is 64 bit ready, uses MSI techniques. Please report any anomalies found.

New features

  • Edit in preview
  • Locale per report
  • Updated integration library
  • Updated help

Bugfixes / Improvements

  • HDE 5078 A repeated group header shows incorrect record
  • HDE 5986 Report footer section with option ‘Section can span multiple pages’ can print over the bottom margin
  • HDE 5954 Focus does not always move to previewer when clicked
  • HDE 5430 Removing a Stored Procedure table from a report does not remove the associated parameters
  • HDE 5995 ‘Open file after export’ option does not work after multi-page HTML export
  • HDE 5138 Page header can display weird values on the last page
  • HDE 5030 ‘Page Number’, ‘Total Page Count’ and ‘Page N of M’ special fields return different values when the options ‘Reset page number after this section’ is set and used from a function
  • HDE 5974 Browse data on a Stored Procedure table now returns empty list instead of an error message
  • HDE 5929/5951 Error 4509 when running report with a subreport
  • HDE 5959 Accelerator keys do not work for checkbox and combobox controls
  • HDE 5969 ‘Count’ and ‘Distinct Count’ summary types are formatted as numbers instead of integers
  • HDE 5973 Current connection in Database Expert for SP based reports shows strange tables
  • HDE 6021 Cannot select table link in Database Expert after deleting a table
  • HDE 5963 Edit text in previewer does not show edit window
  • HDE 6024 Accelerator keys for recent files in the File menu do not work
  • HDE 6030 GDI resource leak
  • Edit in preview
    • Fixed ‘Array out of bounds’ errors
    • ‘Esc’, ‘Ctrl+Up and ‘Ctrl+Down’ keys in previewer do not work as expected
    • Position of objects in design tab are not always in sync with preview tab
    • Undo in previewer does not always undo the changes made
    • Fixed moving a field within the same section with the mouse in the previewer
  • Library:
    • The dialog used when a function in a report contains an error does not show the report name in a web application
    • The ExportReport.wo and ExportReportDialog.wo web components now have a checkbox for Excel native formatting for XLS export

This version uses a drop-dead date and expires at April 1, 2019.

DataFlex Reports v7 runs side-by-side with older versions. Note that saving the report definition file (.dr) with v7 makes it not accessible with v6.2 or older anymore.

New Installer

DataFlex Reports is the first product that uses a new modern product installer. The layout is restyled, it is 64 bit ready, uses MSI techniques. Please report any anomalies found.

New features

  • Edit in preview
  • Locale per report
  • Updated integration library
  • Updated help

Bugfixes / Improvements

  • HDE 5834 Last field in SQL statement is not displaying
  • HDE 5836 Problem with filters using a SQL based report
  • HDE 5876 Options ‘Repeat Group Header’ and ‘Print next section on same page’ are ignored
  • HDE 5917 Problem when deleting a Group name object used in a chart
  • HDE 5894/5901 DR 6.2 shows the DR 7.0 help when help is copied to DF folder from installation
    (fixed starting 7.0, no fixed 6.2 version available)
  • HDE 5944 Problem with filters on dates with descending index using embedded (DataFlex)
    database
  • HDE 5945 Object positioning using a function does not work in combination with variable height
    option
  • Edit in preview
    • Cannot select fields when report contains a page layer
    • Cannot select fields when behind a box object
    • Progress popup no longer shows when editing in preview
    • Performance improvements
    • GPF when moving fields to different sections

This version requires entering your DataFlex Reports 7.x license code or runs in a 60 days evaluation mode. New license codes will be made available in due course.

DataFlex Reports v7 runs side-by-side with older versions. Note that saving the report definition file (.dr) with v7 makes it not accessible with v6.2 or older anymore.

New Installer

DataFlex Reports is the first product that uses a new modern product installer. The layout is restyled, it is 64 bit ready, uses MSI techniques. Please report any anomalies found.

New features

  • Edit in preview
  • Locale per report
  • Updated integration library
  • Updated help

Bugfixes / Improvements

  • HDE 5716 Function Explorer does not save changes when switching between functions
  • HDE 5793 Dragging a .dr file with accentuated characters (for example umlaut) onto DR studio does not open the report
  • HDE 5787/5768 Setting the option Variable Height in a sub-section (i.e. Details B) can cause a GPF error
  • HDE 5735 Translation error in crosstab wizard
  • HDE 5718 Median calculation is incorrect
  • HDE 5364 Add “Administrator” to DR caption bar when running in administrator mode
  • HDE 3630 Show field numbers in the Field Explorer
  • HDE 5198 a SQL() function without a connection in the report should give an error message
  • HDE 5372 Add an option to center a field on the page
  • HDE 5758 Move objects using Ctrl+Shift+Cursor keys in large increments
  • HDE 5335 Allow drDistinctCount to work with all data-types
  • HDE 5697/5849 Starting with version 6.2 filters on the Date datatype do not work with the DataFlex (embedded) database anymore
  • HDE 5720 Crosstab totals are sometimes incorrect
  • HDE 5138 When exporting to RTF a black bar and extra space can occur
  • HDE 5681 Error message when using version 6.2 Maintenance utility
  • HDE 5743/5804 Starting with version 6.2 a Number type in the DataFlex (embedded) database without decimals is converted to an integer and can cause conversion errors
  • HDE 5811 Find by Function ID option does not find the function
  • HDE 5306 Incorrect Font size when exporting to PDF in high quality mode

What is new in version 6.2

Crosstab/Pivot-table support

DataFlex Reports 6.2 introduces a crosstab field type (also known as a pivot-table) which allows you to display your data in a table. All summaries are automatically calculated or you can use a custom function for your summaries. In addition you have full control over how the lines, margins etc. in the crosstab are displayed. In order for crosstabs to work properly you should set the ‘Section can span multiple pages’ option for the sections in which crosstabs are placed. The crosstab wizard can automatically set this option for you.

 

Side-by-Side assembly

The DataFlex Reports Studio is now able to run as a side-by-side assembly. This means it no longer relies on any registered components to operate (also known as ‘regfree’) eliminating the risk of conflicts or missing shared components – such as CodeJock.

DPI scaling support

Support for dot per inch (DPI) scaling has been added to all toolbars, menus and context menus. In addition newly designed icons – ranging from small to large – have been added to the DataFlex Reports Studio and Integration Library.

New formatting and conversion functions

A number of new build-in formatting function 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 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.

DSN-less connection string builder

A connection string builder option has been added to the ODBC connection wizard for DSN-less connections. Depending on the driver you select you will be prompted for all the required information to create the connection. You can easily modify the connection string at runtime use the integration library included with the Developer Edition of DataFlex Reports.

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.

Datasource connection errors option

A new option ‘Show datasource connection errors’ is now available. With this option all errors which occur when you connect to a datasource are reported which can help you determine why you cannot connect to a particular datasource.

Import/Export of RDS data

RDS (Runtime DataSource) table structures and sample data can now be exported and imported. 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.

Bigint support

Support for 64 bit integers has been added to all the Database drivers supplied with DataFlex Reports. If you use any 64 bit integers in your database(s) simply run ‘Check Database’ from the DataFlex Reports Studio or use the Maintenance utility to start utilising this new data type.

Improved Barcode support

Barcode support has been improved with a new option to set the default barcode type and an option to display the humanly readable text which appear underneath some barcode types. Furthermore you can now change a parameter field to a barcode.

SQLite driver

SQLite is a widely used zero-configuration SQL database. It is used by DataFlex Reports for its internal data storage. The new SQLite driver included in DataFlex Reports is a native driver and does not rely on an installed ODBC driver or any other dependencies. Just like the ODBC driver the SQLite driver allows you to base your reports on a SQL statement and supports the SQL() function.

What is new in version 6.2

Crosstab/Pivot-table support

DataFlex Reports 6.2 introduces a crosstab field type (also known as a pivot-table) which allows you to display your data in a table. All summaries are automatically calculated or you can use a custom function for your summaries. In addition you have full control over how the lines, margins etc. in the crosstab are displayed. In order for crosstabs to work properly you should set the ‘Section can span multiple pages’ option for the sections in which crosstabs are placed. The crosstab wizard can automatically set this option for you.

Side-by-Side assembly

The DataFlex Reports Studio is now able to run as a side-by-side assembly. This means it no longer relies on any registered components to operate (also known as ‘regfree’) eliminating the risk of conflicts or missing shared components – such as CodeJock.

DPI scaling support

Support for dot per inch (DPI) scaling has been added to all toolbars, menus and context menus. In addition newly designed icons – ranging from small to large – have been added to the DataFlex Reports Studio and Integration Library.

New formatting and conversion functions

A number of new build-in formatting function 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 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.

DSN-less connection string builder

A connection string builder option has been added to the ODBC connection wizard for DSN-less connections. Depending on the driver you select you will be prompted for all the required information to create the connection. You can easily modify the connection string at runtime use the integration library included with the Developer Edition of DataFlex Reports.

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.

Datasource connection errors option

A new option ‘Show datasource connection errors’ is now available. With this option all errors which occur when you connect to a datasource are reported which can help you determine why you cannot connect to a particular datasource.

Import/Export of RDS data

RDS (Runtime DataSource) table structures and sample data can now be exported and imported. 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.

Bigint support

Support for 64 bit integers has been added to all the Database drivers supplied with DataFlex Reports. If you use any 64 bit integers in your database(s) simply run ‘Check Database’ from the DataFlex Reports Studio or use the Maintenance utility to start utilising this new data type.

Improved Barcode support

Barcode support has been improved with a new option to set the default barcode type and an option to display the humanly readable text which appear underneath some barcode types. Furthermore you can now change a parameter field to a barcode.

SQLite driver

SQLite is a widely used zero-configuration SQL database. It is used by DataFlex Reports for its internal data storage. The new SQLite driver included in DataFlex Reports is a native driver and does not rely on an installed ODBC driver or any other dependencies. Just like the ODBC driver the SQLite driver allows you to base your reports on a SQL statement and supports the SQL() function.

What is new in version 6.2

Crosstab/Pivot-table support

DataFlex Reports 6.2 introduces a crosstab field type (also known as a pivot-table) which allows you to display your data in a table. All summaries are automatically calculated or you can use a custom function for your summaries. In addition you have full control over how the lines, margins etc. in the crosstab are displayed. In order for crosstabs to work properly you should set the ‘Section can span multiple pages’ option for the sections in which crosstabs are placed. The crosstab wizard can automatically set this option for you.

Side-by-Side assembly

The DataFlex Reports Studio is now able to run as a side-by-side assembly. This means it no longer relies on any registered components to operate (also known as ‘regfree’) eliminating the risk of conflicts or missing shared components – such as CodeJock.

DPI scaling support

Support for dot per inch (DPI) scaling has been added to all toolbars, menus and context menus. In addition newly designed icons – ranging from small to large – have been added to the DataFlex Reports Studio and Integration Library.

New formatting and conversion functions

A number of new build-in formatting function 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 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.

DSN-less connection string builder

A connection string builder option has been added to the ODBC connection wizard for DSN-less connections. Depending on the driver you select you will be prompted for all the required information to create the connection. You can easily modify the connection string at runtime use the integration library included with the Developer Edition of DataFlex Reports.

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.

Datasource connection errors option

A new option ‘Show datasource connection errors’ is now available. With this option all errors which occur when you connect to a datasource are reported which can help you determine why you cannot connect to a particular datasource.

Import/Export of RDS data

RDS (Runtime DataSource) table structures and sample data can now be exported and imported. 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.

Bigint support

Support for 64 bit integers has been added to all the Database drivers supplied with DataFlex Reports. If you use any 64 bit integers in your database(s) simply run ‘Check Database’ from the DataFlex Reports Studio or use the Maintenance utility to start utilising this new data type.

Improved Barcode support

Barcode support has been improved with a new option to set the default barcode type and an option to display the humanly readable text which appear underneath some barcode types. Furthermore you can now change a parameter field to a barcode.

SQLite driver

SQLite is a widely used zero-configuration SQL database. It is used by DataFlex Reports for its internal data storage. The new SQLite driver included in DataFlex Reports is a native driver and does not rely on an installed ODBC driver or any other dependencies. Just like the ODBC driver the SQLite driver allows you to base your reports on a SQL statement and supports the SQL() function.

What is New in version 6.0?

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.

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.

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.

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.

Changes between Release Candidate I & II

  • Updated documentation
  • PreviewWaitingGIF() property added
  • Added option to set the ‘Wrap state’ of existing reports to the Maintenace utility

Bug fixes:

Library:

  • The cWebDRReportViewer class is updated.
  • Added support for DataFlex 19.0 tab-workspaces
  • cDRPreviewWindow class now sends PreviewPaint when a resize occurs (for tab-workspace support)
  • 18.0 library and higher; web.tpl (template) replaced with webPDF and webHTML templates
  • 19.0 library; icon and bitmap update

What is New in version 6.0?

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.

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.

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.

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.

Changes between Beta II and Release Candidate

  • HDE 4752 https://support.dataaccess.com/Forums/showthread.php?60524-Arrange-Object-spacing-possible-YAFR
  • https://support.dataaccess.com/Forums/showthread.php?60693-DR6-0-Display-Status-Panel-flickering
  • https://support.dataaccess.com/Forums/showthread.php?60704-Text-field-Don-t-work-with-special-characters
  • Exporting reports with charts in HTML and PDF draws the chart upside down
  • Chart legend marker ‘width’ and ‘height’ values were swapped
  • Fixed Barcode error messages
  • Fixed ‘invalid data type’ errors in copy/paste of subreports
  • Fixed problem with adding existing report as a subreport changing tab names in the Studio
  • Fixed problem with PDF passwords no longer working
  • HDE 4686 Paint problem with current selection of combo box
  • HDE 4762 First row on every page of Excel export is empty when using ‘Data only’ export
  • HDE 4764 Error opening Excel 2007 export file
  • Fixed problem with varchar(max) fields in ODBC being converted to ‘string’ fields instead of ‘memo’ fields
  • Fixed problem with summaries on functions not working properly
  • ‘One or more table mismatches’ error in check database when using tables from multiple schemas
  • Changing the label size did not change the size of the details section
  • Fixed errors hen using some of the Barcode constants (constants with dash symbols)
  • Images on RDS are now 1 inch by 1 inch by default if no image sample is available
  • Fixed problems with copying/pasting objects between reports based on different data sources
  • Fixed error messages when copying/pasting from the report explorer

What is New in version 6.0?

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.

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.

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.

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.

Changes between Beta I and Beta II

  • JIT function pre-compiler
  • Added option for case-insensitive compare in functions. We recommend you turn this option on for all new reports (by default this option is turned on for new reports and off for existing reports).
  • '(null)' values will no longer appear in RDS reports
  • Variable length Memo and Binary fields.
  • Anchor support
  • Helper for drawing Lines/Boxes over sections. You can create Lines and Boxes spanning multiple sections by inserting a Line/Box while holding the Ctrl key.
  • New ‘TableNameAlias’ function in OCX
  • Updated integration library

Bug fixes:

What is New in version 6.0?

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.

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.

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.

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.

Changes between 5.0.1 and 6.0

Implemented suggestions:

Bug fixes:

Library:

  • HDE 4403: Replaced DownloadURL call in ExportReportToDownloadURL with CustomDownloadURL
  • HDE 4439: Implemented suggestion to add file extension to export filename if not specified in DRExportOptions.dg
  • HDE 4427: Repaint of preview after PreviewFind
  • HDE 4636: pbServerOnEscape set to true in DRPDFModalDialog.wo
  • HDE 4665: Added new method to set the color of the preview canvas
  • Moved the code previously generated by the wizard for the OnProgressRecordsRead and OnProgressFormatPage methods to the cDRReport class
  • Added new preview option for windows implemented in class cDRDesktopPreview
  • Excluded all methods unavailable in web applications in cDRReport with conditional compiler switch
  • Moved all methods and properties from cWebDRReport to cDRReport, the cWebDRReport is now an empty class and the wizard will generate a cDRReport

Wizard Changes:

  • Added new preview option – DesktopView – similar to the tool-panel but with additional button in the windows tak bar
  • OnProgressRecordsRead and OnProgressFormatPage methods are no longer generated

DataFlex Reports
DataFlex Reports comes in two versions, the Standard edition and the Developer edition. However, pre-releases only support the Developer Edition.

Standard Edition
The DataFlex Standard edition is meant for end-users in mind, who want to create and run their own reports. Reports can be created from any SQL type of DBMS, as well as the embedded DataFlex database. Each license is meant for own, individual use.

Developer Editon
This version can do the same as the Standard edition, but it is developed with the software developer in mind. As a developer you can create and integrate reports in your application. In case of Windows applications, the reports and the appropriate runtime components, can be distributed freely along with your application.

Reports can also be integrated in web applications. For deployment, a small fee pre server is required.

v5.0 Beta I
v5.0 Alpha I
v4.0 RC
v4.0 Beta III
v3.0 RC 2
v3.0 RC 1
v3.0 Beta 3
v3.0 Beta 2
v3.0 Beta 1
v3.0 Alpha 2
v3.0 Alpha 1
v2.1 Beta 1
v2.0 Beta 1
v2.0 Alpha 2
v2.0 Alpha 1

Quotes

What others say about DataFlex Reports 

FAQ