Digital Metaphors ReportBuilder v21.02 Enterprise (Tokyo/Rio/Sydney/Alexandria, 32/64bit) Patched

Digital Metaphors ReportBuilder v21.02 Enterprise (Tokyo/Rio/Sydney/Alexandria, 32/64bit) Patched
Digital Metaphors ReportBuilder v21.02 Enterprise (Tokyo/Rio/Sydney/Alexandria, 32/64bit) Patched


ReportBuilder is the de-facto standard for Delphi reporting solutions. The genesis of ReportBuilder was the desire to deliver a product that does for reporting what Delphi does for application development. In that spirit, ReportBuilder provides both a RAD environment and an object-oriented platform for solving the reporting equation. The RB story continues to be written every day as we continue to evolve the product and collaborate with the RB community. It’s our passion.

With ReportBuilder Enterprise, you get everything included in ReportBuilder Professional, plus the RAP language, which allows developers and end users to code calculations and complex event handlers at run-time. RAP enables the entire report definition (data, calculations, and layout) to be stored outside of the application executable.

In the introduction to ReportBuilder, the reporting equation is described. The reporting equation divides reporting into four main activities:

In ReportBuilder Enterprise, the goal is to deliver a full-fledged reporting solution to end users. This goal is achieved by delivering visual, easy-to-use solutions in each of these four areas. This screen shot of the ReportBuilder Report Designer shows the ergonomic design of the user-interface.

Each of the four areas of reporting has a representative notebook tab containing a visual environment for the creation and configuration of components within that area. The results of each area then become inputs to the next area: data feeds into calculations, calculations feed into components within the report layout, and the report layout is rendered into a preview of the report. The implementation used by ReportBuilder Enterprise for each area of reporting is described below.

Data
Within the work environment of the Data tab, end users can quickly create dataviews, which can then be used to supply data to reports. Dataviews are usually created via the Query Wizard or Query Designer. Both of these tools are visual; they also allow the end user to select the tables, fields, search criteria, and sort order necessary for the report. Behind the scenes, an SQL statement is generated and used to retrieve the data from the database. A screen shot of a completed dataview is shown below.

The solution described above is the standard behavior within the data workspace. However, the developer can customize this user-interface by doing one of three tasks:

Register a replacement query wizard or query designer.
Remove the query wizard or query designer.
Create new dataview template classes that can simplify the data selection process even further by establishing the relationship between the tables in the database and presenting an alternative user-interface (such as a single form that allows search/sort criteria to be entered).
The bottom line is that the Data area contains a turnkey solution that can be used out-of-the-box, but if customizations are needed, an architecture has been provided so that those customizations are possible.

Calc
The Calc workspace is used to manage the RAP code associated with the Report. The Calc workspace contains a tree view of the report, all the bands within the report, and all the objects within each band. When a band or component is selected, all the events for that component are shown in a list. The user can then select an event and code the event handler in the syntax-sensitive code editor at the bottom. The following screen shot shows an OnPrint event as coded for a Line component.

This screen shot shows the Calc workspace in its most feature-rich and complex configuration. Development work completed here can be passed on to end users so that they can modify it, locked down so that end users can only view it, hidden completely so that end users do not know it is there. The most scaled-down version of the Calc tab is provided by the dialog only interface, where no Calc tab exists at all, and a single syntax-sensitive code-editor dialog is accessible from the Calculations… menu option of the variable component. The user-interface and behind-the-scenes architecture has been made highly scalable in order to meet the various needs of developers.

Design
The Design workspace contains the actual layout of the report. The user-interface is identical to the one presented to developers using ReportBuilder at Delphi design-time; in other words, it is full-featured and professional. The Office97 interface-style makes the Design workspace especially easy to learn for end users. A Report Wizard is available for creating reports quickly. You can customize this interface by replacing any of the dialogs it uses and by registering your own report wizards.

Preview
The Preview workspace contains the rendered report. The report can be printed to the printer or to various file formats from this workspace.

RB 20

Last update on July 31, 2019 under What's New

Designer

new Ruler margins
new FontList, filter out vertical fonts (@FontName)
new Group Dialog
internal redesign
handle cases where datafield(s) no longer exists
handle cases where no datafields exist
new Delphi IDE About Box ‘installed products’ RB entry

New High DPI

Windows 10 features
Use latest Delphi for best support
Per Monitor DPI
DPI Change support
Toolbars/menu library, Object Inspector
Designer, Viewer, Dialogs etc
RB Forms architecture support

New Cloud Drive

Export directly to popular cloud drives
Google Drive, OneDrive, and DropBox support
Stream files or save to disk
Export to multiple cloud drives
Preview, Print/Export dialog support
Use as a stand-alone cloud uploader

Dialogs

new Print Dialog re-design
Separation of print and export functionality
Navigation bar to toggle display
Cloud drive support
UseLegacyPrintDialog property for backward compatibility
Export check ‘File in Use’ and display warning message
new AutoSearch Dialog
enhanced to align controls for cleaner display
display True/False drop-down list for Boolean field type
new Form.PopupParent assignment throughout

Preview

new Export to File toolbar button
new Cloud Drive toolbar button
new Thumbnail Size control options
Small, Medium, Large options added to popup menu
ThumbnailSize property added
Thumbnail auto size option
new ThumbnailMousewheel support
new ThumbnailEnhanced resolution for small sizes
new PageIncrement limit decreased to 20

Engine

optimized component SaveOrder calc, when exporting to XlsData, Delimited file
new left to right columns support for toggling Band.Visible

Output Devices

new PDF, 256 bit AES encryption
new PDF, Attachment description support
new PDF, Attachment streaming support
new PDF, Form field password (hidden character) option
new PDF, Form field multiline support
new PDF, Form field character separator option
new PDF, PDF/A3 ZUGFeRD auto metadata processing
new PDF, RichText embedded image support (Infopower)
new PDF, NeedsAppearances property
new PDF, PDF/A Checkbox support
new PDF, PDF/A Symbol font support
new Xlsx, export shapes as cell range formatting (border, fill)
new Xlsx, export lines as cell range formatting (border)
new Xlsx, only skip empty strings when AutoSize False
new Email, OutLook plugin, show modal Outlook Client
new FileDevice.Cancel, delete file logic
new Viewer, OnCancel event

RCL

new DBCheckbox, support for Boolean and String field datatypes
new Image, enhanced rendering for transparent bitmap scaling
new HyperlinkHint property for Text, Image components

Archiving

new RAF file support > 4GB
ArchiveDevice, write 64bit page entries (new archives)
ArchiveReader, check file signature and read 32 or 64 page entries
ArchiveReader.ArchivePageCount
return ArchivePagecount without calling Print (prop getter)

REST

new DocumentService, enhanced Format property to support:
File extension: PDF, Xlsx, etc.
DeviceName: XlsReport, XlsData, etc.

DADE

new File | Merge From File… menu option (Designer)
new SQL validation optimzation
use Limit 0 rather than where ‘c’ <> ‘c’
new Query Designer, autojoin suggestion datatype checking
new Query Designer, prompt user when SelectedFields = 0
new SQL error description, enhanced to include SQL statement

RAP

new RAP System Constants plugin architecture
enables registering constants to RAP Code Toolbox
new Compiler, support constants for enum types
new RTTI for TBrush, TPen classes

Server

new WebTier, retrieve PDFSettings stored w/report definition
new ClientReport, GetPDFSettings method to retrieve report PDFSettings
new TPersistentWriter/Reader (used by Server streaming)
new WebTier, ErrorPage to show exception stack trace
requires Delphi 10.2 and later
requires JCLDebug or similar addon that implements SysUtils hooks


Information
Users of Guests are not allowed to comment this publication.