In the new version of FastReport for DBA we have added support for high-resolution screens in the designer and preview of the prepared reports.
We also added new exports DXF, XODT, XODS, PDF/A-1a, PDF/A-2u.
Added new Visual Studio-styled icons. You may switch between icon packs in the "View/Options/User Interface" window (or, "File/Options/User Interface" if you use ribbon UI):
The new icons are well suited for hiDPI screens.
There are also new barcodes: Swiss QR Code, ITF-14, Deutsche Post Identcode, Deutsche Post Leitcode, Japanese PostNet:
Added ability for the Text object to display DB filed names in a simplified form when designing a report. You can activate this option in the "View/Options/Objects appearance" window. This option is off by default. When you turn it on the Text object with a single DB field will display the field name part only, with no datasource name:
Added ability to set up each cell in the Matrix object's corner area. To do this use the cell's context menu and its commands "Split cell", "Merge cells":
Added ability to connect to ElasticSearch. Connection is available in data wizard and from code.
Significantly improved and redesigned connection to the CSV data source.
VisibleExpression, PrintableExpression and ExportableExpression properties appeared. You can use them to adjust the values of the Visible, Printable and Exportable properties depending on some condition:
Full list of changes:
[Engine]
+ added connection to ElasticSearch
+ added new barcodes: Japanese PostNet, ITF-14, Deutsche Post Leitcode, Swiss QR Code
+ added CountDistinct aggregate function (report totals and Matrix object totals)
+ added support of TLS 1.2
+ added new 2 types of UncheckedSymbol for CheckBox
+ added ability to load XML data source by URL
+ added functions of converting numbers to words for Polish, Indian, Persian, Ukranian language
+ added rupee symbol for Indian currency
+ added the Report.Prepare (int pagesLimit) method, which allows to prepare a limited number of pages
+ added ability to align barcodes
+ added property PictureObject.ImageSourceExpression that allows to set expression containing source of image
+ added possibility to use expression in brackets in VisibleExpression, PrintableExpression and ExportableExpression properties
+ added the PictureObject.ImageFormat property, which allows to select the image storage format
+ added property MatrixObject.PrintIfEmpty, which allows displaying the matrix even if it is empty
+ added property Page.LastPageSource, which allows to configure the printer tray for printing the last page of the report
+ added VisibleExpression, PrintableExpression, and ExportableExpression properties
+ added property Report.Tag
+ added "AutoEncode" property for DataMatrix Barcode. By default, if true, it encodes the &1; as a symbol of FNC1. If false, the character is encoded as is.
+ added "OnScriptCompile" event that called when report's script compiles
+ added new TextQuality: SingleBitPerPixel and SingleBitPerPixelGridFit
+ added an ability to split table rows
+ added RUB, BYN and BBYN currencies to ToWordsRu function
+ added an ability to change decimal digits for Number, Currency and Percent formats when UseLocale property is true
+ added property "SplitRows" for MatrixObject. By default, its value is False and in this case rows with the same vaues are joined. If True - rows are split (like TableObject)
* optimized copying streams in some cases
* optimized and unified converter RichText to report objects
* optimized work of VisibleExpression, PrintableExpression and ExportableExpression properties for bands
* improved algorithm of converting RTF to report objects
> these properties allow to set the value of the Visible, Printable, and Exportable properties, depending on the fulfillment of the specified condition
- fixed a bug with incorrect tab width when TextObject.TextRenderType = TextRenderType.HtmlTextRenderer
- fixed a bug with SubreportObject on a page footer band which caused StackOverflow exception
- fixed a bug with Dock and Anchor properties of objects inside table/matrix cells
- fixed a bug leading to System.ArgumentException when drawing PictureObject located outside the band
- fixed a bug with incorrect work of right anchor (Anchor = AnchorStyles.Right) when page has unlimited width
- fixed a bug with replacing a custom font with a default font when preparing a report
- fixed a bug with vertical alignment when converting RTF (by default, now Top instead of Center)
- fixed a bug with converting RTF tables to report objects
- fixed a bug with page sizes could reset after preview
- fixed a bug with printing a RichText object on large Windows scaling was happening incorrectly
- fixed a bug leading to System.ArgumentOutOfRangeException in Substring functions
- fixed a bug leading to System.ArgumentException when drawing PictureObject with some images
- fixed a bug when tables were not displayed when connecting to Advantage Database via ODBC
- fixed a bug where RichText went outside the page
- fixed a bug with recompiling the report script that interacted with ChildBand
- fixed a bug with incomplete copying of the matrix when copying the report page
- fixed bugs when importing DevExpress reports
- fixed bugs when importing RDL reports
- fixed a bug when a band with the FillUnusedSpace property enabled was not displayed again, although there is enough free space
- fixed bugs when importing List and Labels reports
- fixed a bug where the AutoSize property for SvgObject did not work correctly
- fixed a bug with TextObject.AutoShirnk=FontSize when TextObject's size is very small
- fixed a bug with incorrect TotalPages variable value when it used in VisibleExpression
- fixed a bug with converting RichText when RichObject.Text is null
- fixed a bug with web response stream reader when connecting to remote JSON
- fixed a bug while compiling the report with some expressions in the properties VisibleExpression, PrintableExpression and ExportableExpression
- fixed a bug with incorrect checksum calculation in Deutsche Post Identcode barcode
- fixed a bug where the designer crashed when the "Start new page" property is enabled for the page header child band
- fixed a bug where the value of an expression was displayed by the text of this expression
- fixed incorrect drawing of ITF-14 barcode
- fixed a bug with transparency of RichObject
- fixed a bug with text object visibility when Highlight.Visible parameter is enabled
- fixed a bug with work of property PrintableExpression
- fixed a bug with connection to PostgreSQL 12 and newer
- fixed a bug when shifting SubReport to a new page didn't work correctly
- fixed a bug when the data footer break away from the data when property "keep with data" is enabled
- fixed generation of barcode GS1-128
- fixed incorrect value of Total, if it refers to another Total
- fixed a bug where the table was not transferred correctly
- fixed a bug with parsing xml with hexidecimal values, e.g. "To create it:
"
- fixed bug with trying to convert DBNull in empty string when ConvertNulls is disabled
- fixed a bug when PageFooter with PrintOn=LastPage causes to print it on penultimate page
[Designer]
+ added HiDPI support
+ new icons added. Use the designer's "View|Options|User interface" dialog to switch between icon packs.
+ added simplified display of DB field names in the designer
+ added collapse all/expand all button and search field for Report tree and Data tree
+ improved the behavior of the page panel
+ added ability to copy data source
+ added import of DevExpress reports saved in XML format
+ added the ability to add text and pictures by dragging and dropping them from the browser
+ added the ability to edit the number of rows and columns of the table by dragging the mouse
+ added loading of RTF texts, tables and styles when converting DevExpress file
+ added possibility to load CSV files via URL
+ added backlighting of the band that the selected element will located on when dragging is completed
+ added an ability to open subreport page by double-clicking on its object
+ added an ability to change fonts for Code Tab, Text Editor and Expression Editor
+ added an ability to replace pictures with drag & drop
+ added an ability to open report file by drag & dropping
+ added an ability to scroll the report horizontally while holding down the Shift key
+ added ability to drag & drop picture in format png, jpeg, jpg, gif, ico, bmp, tif, tiff, emf, wmf and text files in format txt, rtf
+ added ability to paste picture and text on page from clipboard
+ added ability to create new report page using: "+" button on the pages panel, double-click on empty space on the pages panel, "Ctrl+N" shortcut
* when changing the window, the context menu now closes
* now during autosave the selected item from the properties window is not reset
* changed focus order of elements when clicking "tab" on a tab with creating swiss QR
- fixed a bug leading to the crash of the report designer with an incorrect table in the data source.
- fixed a bug with index of bounds in SQLBuilder in Designer
- fixed a bug where the dialog page did not open if it had a GridControl
- fixed bugs in Right to Left mode
- fixed a bug when rescaling the dialog form
- fixed a bug with adding a barcode, leading to creation of a barcode with the wrong type
- fixed a bug when dragging from functions created a NUD and an empty TextObject
- fixed a bug when the RichTextBoxControl was not rendered correctly in the dialog workspace
- fixed scaling issues in the WelcomeForm and Wizard windows
- fixed a bug with copying an object, when an object with the same name was created
- fixed a bug with empty database name after reloading the report
- fixed a bug when double click to arrow buttons on report tab creates a new report page
- fixed a bug where switching properties to alphabetical order did not work
- fixed a bug with loading page size when converting DevExpress file
- fixed a bug, when empty string in Datamatrix barcode causes exception
- fixed a bug where the gauge window had the wrong width
- fixed a bug where drag&drop to the matrix didn't work
- fixed a bug leading to System.FormatException when opening DevExpress files
- fixed a bug "Count cannot be less than zero." when opening DevExpress files
- fixed a bug with moving objects in the report tree while holding down the Ctrl key
- fixed a bug with drop down menu of select color button
- fixed a bug when changing parameters after adding a line caused exception
- fixed a bug with creating the Intelligent Mail barcode
- fixed a bug with JSON-connection in Connection Wizard
- fixed a bug with incorrect drawing of horizontal guides
- fixed a bug when the width of objects was reset after closing Preview with enabled right anchor
- fixed a bug when trying to set an incorrect RowSpan value to a MatrixObject cell
- fixed a bug with dropping color, width and style in Border editor
- fixed a bug with resizing PolyLineObject/PolygonObject, when it's copied with Ctrl+Drag
- fixed a bug with inactive context menu "Size Mode" for SVG object
- fixed a bug when subreport cannot be deleted when page linked to it was deleted before
- fixed a bug when the buttons in the "Panel" in the "View" tab did not match the "Visible" property of the corresponding windows
[Preview]
+ added "About" button in toolbar of preview window
+ added an ability to scroll the report horizontally while holding down the Shift key
+ added exports menu editor
> new editor is available in user interface options; exports can now be removed from exports menu
* data source menu in Text Editor is now hidden in Preview
* "Delete Page" button now disabled in Preview when only one page generated
- fixed a bug with saving prepared reports containing converted RichObject
- fixed a bug where the percentage of scale in Preview could be displayed incorrectly
- fixed a bug leading to System.ObjectDisposedException when re-preparing the report
- fixed a bug where the report could only be saved in the Box, regardless of the cloud storage selected in the menu
[Exports]
+ added exports to DXF, XODT, XODS, PDF/A-1a, PDF/A-2u
+ added support of ODF 1.2 in export to ODT/ODS
+ added option when export to Word 2007 "Do not add section breaks on page breaks". By default, both page breaks and section breaks are added.
+ added property ReportPage.ExportAlias, which allows to set the page name when exporting to Excel 2007
+ added ability to split pages in export to XML
+ added support for Padding property in Word2007 export
* now, in Excel 2007 export for sheets without pictures, files with a description of pictures and relations to them are not created
* optimized saving of embedded fonts in PDF-export. File size has decreased significantly.
- fixed page-break in Html export (PageBreaks property)
- fixed SVG export with "Multiply export" parameter
- fixed SVG export bug on hidpi monitor
- fixed the names of files saved in the zip archive
- fixed tab symbols width when export RichObject
- fixed XPS export bug where documents exported on Linux would not open on Windows
- fixed bugs with incorrect work of Anchor and Dock properties when exporting pages with unlimited width
- fixed a bug in Excel 2007 export of text objects with enabled HtmlParagraph render type. Disable WYSIWYG export option to export text instead of images.
- fixed a bug of export to ODF when the document did not open in MyOffice
- fixed a bug with closing cell with RichText when exporting to RTF
- fixed a bug when exporting objects with rendering mode HtmlParagraph
- fixed a bug with exporting line with arrow cap in layered export to Word 2007
- fixed a bug with exporting line with arrow cap in export to PowerPoint 2007
- fixed saving report to Box
- fixed saving report to OneDrive
- fixed saving report to Google Drive
- fixed a bug leading to System.OutOfMemoryException when exporting to PDF
- fixed a bug with creation of incorrect file when exporting to Excel 2007 with big amount of pages and page breaks option
- fixed a bug where export to image did not take into account the transparent background of the report
- fixed a bug leading to System.NullReferenceException when exporting to Excel 2007
- fixed validation errors in export to ODT/ODS
- fixed a bug in ODT-export when the file did not open correctly in Word 2019
- fixed a bug with incorrect line position when exporting to Word 2007
- fixed a bug when exporting to Excel 2007 in the "Seamless table" mode leading to table breaks, incorrect merging cells and incorrect exporting of images
- fixed a bug where links with Russian letters did not work in PDF export
- fixed a bug where the dates of creation and editing of the document did not match the equivalents in the metadata in PDF/A-1a export
- fixed a bug while exporting to Excel 97 causes exception "Huge SAT not implemented"
- fixed a bug with exporting texts containing ampersand '&' in Excel 2007 export
- fixed a bug while exporting MapObject to PowerPoint
- fixed a bug with saving default theme in export to Excel 2007
- fixed a bug with exporting gradient fills with owner or user password in export to PDF
- fixed a bug with encryption of digital signature in PDF-export when protecting a document with a password
- fixed a bug with paragraph offset in export to OpenOffice Writer
- fixed a bug with exporting strings containing only spaces in DXF export
- fixed a bug in PDF export, leading to disappearance of spaces when there are tabs in the report
- fixed a bug with exporting page footers when export to Excel 2007 in seamless table mode
- fixed a bug with exporting "\" character in Excel 2007 export
- fixed a bug with incorrect indents in export to OpenOffice Writer
- fixed a bug with incorrect size of picture in export to RTF
- fixed a bug with page breaks in export to OpenOffice Writer
- fixed a bug with paragraph offset in export to OpenOffice Writer
- fixed a bug with text justify in exports to OpenOffice Writer and OpenOffice Spreadsheet
- fixed a bug in Excel export (BIFF8)
- fixed a bug with printing of layered Html export, when the report contains pages with landscape orientation
- fixed a bug where exporting to EMF called an exception
- fixed display of objects with negative height/width for layered Html-export
- fixed bugs when exporting a multi-page report in XML
- fixed a bug when PDF export generated incorrect file when EmbeddingFonts and InteraciveForms properties equal True
- fixed view of background on BarcodeObject at Pdf and Html export
- fixed bugs when displaying Shape, Barcode, Polygon etc. with fill (or background) in all exports with table layout