Installer new “All Languages” option when selecting language resources Designer new ReportWizard, restore field to original position when de-selected new ReportTree, optimze to eliminate flicker new ReportTree, set workspace focus when component selected new DataTree, optimize to eliminate flicker new DataTree, update selected DataPipeline when report/subreport selected new Object Inspector, improved VclStyle support User Interface Full Article…
Search the Wiki
Viewing 1 to 35 of 409 items
Merging Archive Files
Report archive files are an exact replication of the report output when it is generated. While the report itself can be dynamic in nature by accepting different data, event code, or parameters, an archive is a direct snapshot of the output and is unchanging. One way to merge multiple outputs into a single file is Full Article…
Comments Off on Merging Archive Files
Merge Reports with Subreports
There are numerous ways to merge multiple reports into one. One way is to utilize subreports. This involves creating a main “container” report with a single detail band only. Inside the detail, a number of subreports are added to hold the reports needing to be merged. Full Article…
Comments Off on Merge Reports with Subreports
EPC QR Codes
The European Payments Council (EPC) is an organization that plays a significant role in the development and management of payment schemes in the Single Euro Payments Area (SEPA). The EPC has introduced standardized form of Quick Response (QR) codes designed to facilitate seamless payment experiences within the European Union. These codes serve as a bridge Full Article…
Comments Off on EPC QR Codes
RB 22
Packages New VersionInfo support (.res metadata) New PlatformTargets support for Delphi IDE (.res meta data) 32-bit and 64-bit Build w/run-time Packages support **Delphi 11.2 only Designer new ReportWizard enhancements to improve group layouts Preview new Thumbnails optimization to generate only when enabled PDF Component new LoadFromStream method new DataPipeline, DataField properties to allow binding to Full Article…
Comments Off on RB 22
PDFComponent Fundamentals
Overview Use PDFComponent to embed a PDF document in a report. This component behaves like a section style subreport – starting on a new page and generating a report page for each PDF page. Key Properties PDFFileName – specifies PDF file PDFPassword – specifies password (if needed) PDF Reader This component requires a PDF Reader Full Article…
Comments Off on PDFComponent Fundamentals
Data Matrix – GS1
ReportBuilder 22+ introduced the GS1 property which adds the FNC1 character automatically. The article below applies to ReportBuilder 21- or if manual encoding is desired. ReportBuilder provides the tools necessary for the developer to support GS1 Data Matrix. There are two options for ASCII encoding of the Data Matrix component (TppDataMatrixSettings.EncodeType property): ASCII and ASCIIManual. ASCII Full Article…
Comments Off on Data Matrix – GS1
Cloud Drive Overview
Comments Off on Cloud Drive Overview
Cloud Drive Setup – Dropbox
This service requires OAuth2 authentication meaning that the reporting application will not need to know the user’s credentials in order to connect and send email. To use this service, the application must first be registered in the Dropbox API Manager where a Client ID, Client Secret, and Redirect URI can be created Full Article…
Comments Off on Cloud Drive Setup – Dropbox
Cloud Drive Setup – OneDrive
This service requires OAuth2 authentication meaning that the reporting application will not need to know the user’s credentials in order to connect and send email. To use this service, the application must first be registered in the Microsoft Azure Portal where a Client ID, Client Secret, and Redirect URI can be created and assigned to Full Article…
Comments Off on Cloud Drive Setup – OneDrive
Cloud Drive Setup – Google Drive
This service requires OAuth2 authentication meaning that the reporting application will not need to know the user’s credentials in order to connect and send email. To use this service, the application must first be registered in the Google API Manager where a Client ID, Client Secret, and Redirect URI can be created and assigned to Full Article…
Comments Off on Cloud Drive Setup – Google Drive
How To… Multiple Email Plugins
Background: The email feature in ReportBuilder utilizes numerous email plugin classes that allow emails to be sent in various ways. See the article on email fundamentals for more information about the design of this feature. With the introduction of the Web Mail plugins such as Gmail, it is increasingly necessary to offer users of RB Full Article…
Comments Off on How To… Multiple Email Plugins
Web Mail Setup – Outlook.com
This service requires OAuth2 authentication meaning that the reporting application will not need to know the user’s credentials in order to connect and send email. To use this service, the application must first be registered with Microsoft Entra where a Client ID, Client Secret, and Redirect URI can be created and assigned to the corresponding Full Article…
Comments Off on Web Mail Setup – Outlook.com
Web Mail Setup – Gmail
This service requires OAuth2 authentication meaning that the reporting application will not need to know the user’s credentials in order to connect and send email. To use this service, the application must first be registered in the Google API Manager where a Client ID, Client Secret, and Redirect URI can be created and assigned to Full Article…
Comments Off on Web Mail Setup – Gmail
Web Mail Overview
Background: ReportBuilder includes support for the ability to send exported reports through various web email services. This is done via the REST APIs provided by the supported services. The web email feature is designed with a plugin architecture allowing multiple services to be supported at once. To register a certain plugin, simply add the unit Full Article…
Comments Off on Web Mail Overview
OAuth2 Overview
The OAuth2 (OAuth 2.0) Framework allows third party applications temporary access to a web service account owned by the end-user without the need for the host application to obtain or store login information. Generally speaking, a web service refers to an on-line application which provides a public API to access its functionality. Examples are web Full Article…
Comments Off on OAuth2 Overview
How To…Digitally Sign a PDF
Digitally Sign a PDF from Within ReportBuilder ReportBuilder 21+ includes support for automatically signing an exported PDF document with a valid digital certificate (signature). Background: The PDF file format supports the use of Digital Signatures to ensure a file has not been altered before it is received/viewed. The PDF document can be “signed” using a Full Article…
Comments Off on How To…Digitally Sign a PDF
How To… Show Email Status
Question “Is there a way to show the status of a sent email” Solution Use the TppSMTPCustom.OnStatusChange event to retrieve various status updates from your email server or MAPI compatible email client. This event can be accessed from the TppReport object by typecasting the TppReport.Email object as TppEmail. Sample Delphi code: procedure TForm1.Button1Click(Sender: TObject); begin TppEmail(ppReport1.Email).SMTP.OnStatusChange := EmailStatusEvent; Full Article…
Comments Off on How To… Show Email Status
RB 21
Designer new Designer.AutoSave boolean property new Designer Win 10 per monitor High DPI improvements new TextFileName property editor to use DefaultFileDeviceType Enhanced High DPI – v2 Per Monitor DPI Windows 10 / Latest Delphi Virtual Image List (scaleable images) Form/Dialog save/load state Toolbars/ToolWindows RCL new PDFComponent embed PDF documents in reports (similar to section subreport) Full Article…
Comments Off on RB 21
PDF/A3 ZUGFeRD
ReportBuilder includes the ability to export to PDF/A3 format with further processing to meet the ZUGFeRD specifications. ZUGFeRD is a primarily German invoice standard although it has been adopted by much of Europe at the time of writing this article. All ZUGFeRD invoices require a valid PDF/A3 format PDF with an XML invoice attached to the Full Article…
Comments Off on PDF/A3 ZUGFeRD
RB 20
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 Full Article…
Comments Off on RB 20
REST Client Tutorial (FMX)
ReportBuilder includes REST Services which allows the simple creation of a report REST server that may be accessed via any mobile device using the mobile client components. This article gives an overview of the REST client components, how they are used, as well as some small tutorials. The ReportBuilder REST Client components are installed into Full Article…
Comments Off on REST Client Tutorial (FMX)
REST Server Tutorial
ReportBuilder REST Services allows for the simple creation of a report REST server that may be accessed via any mobile device using the mobile client components. This article gives an overview of the REST Services components, how they are used, as well as a simple tutorial. The ReportBuilder REST Service components are installed into the Full Article…
Comments Off on REST Server Tutorial
TableGrid Fundamentals
Overview The TableGrid component is used to print a table in a report. A table consists of rows and columns that define a grid of cells. Cells may contain objects such as Label, DBText, Memo, Image etc. Simply drag-and-drop the object to the Cell. The Cell by default manages the child object’s boundary based on the Full Article…
Comments Off on TableGrid Fundamentals
How To…Customize PDF/A Metadata
Question “How can I alter the default metadata when exporting to PDF/A?” Solution Use the TppPDFDevice.OnGetPDFMetadata event to retrieve the default metadata and alter it to meet your specific needs. All metadata is in XML format so it is beneficial to use the Delphi built-in XML classes to edit the data. The following example shows how Full Article…
Comments Off on How To…Customize PDF/A Metadata
RB 19
Designer new AutoSave / Recovery for report layout periodically autosave to AppData\Local\RBuilder\Report_autosave.rtm clear on close of designer, but if crash the file remains check for file when designer opens, prompt user to recover RBuilder.ini Designer Preferences for AutoSave, AutoSaveInterval new View | Margins for workspace display page margins for layout workspace store ShowMargins preference to Full Article…
Comments Off on RB 19
RB 18
User Interface new Default theme uses Delphi VCL styles leverage Delphi’s Windows 10 styles new High DPI Monitor support UI scales to any screen resolution new GMap Marker Dialog add GMap markers visually from the designer new Preview popup menu print, zoom, search, etc. from the new menu International new Deploy language modules to custom Full Article…
Comments Off on RB 18
RB 17
Delphi 10 Seattle support for VCL Win32 Delphi 10 Seattle support for VCL Win64 Demos and Tutorials new RBDemos database (SQLite version of DBDemos) new RBDemos FireDAC Connection De installed to Delphi IDE new Converted RB Demos to FireDAC, SQLite RBDemos database new Converted RB Tutorials to FireDAC SQLite RBDemos database REST Service Components New Full Article…
Comments Off on RB 17
Troubleshooting… Outlook 365
The following article provides steps to take if the default Simple MAPI email plugin stops working with the latest version(s) of Outlook or Windows Live Mail. Please follow the steps below to resolve most issues. 1. Download, open, and run the example below on a machine with Outlook or Windows Live Mail as the Full Article…
Comments Off on Troubleshooting… Outlook 365
Using HTTPS
TECH TIP: Configuring the WebTier to Use HTTPS Configuring the WebTier to use HTTPS can be accomplished using one of the options listed below. Options: 1. Use the Delphi Object Inspector to configure the properties 2. Configure the WebTier.IniSettings to load the https params from an .ini file 3. Use the web module OnCreate event Full Article…
Start Web Session
TECH TIP: Start a New Web Session The following example shows how to ask the global WebSessionManager to create a new session. This results in the aWebRequest.SessionID being assigned. uses rsWebSessionManager; procedure TWebModule1.WebModule1waDefaultAction(Sender: TObject; Request: TWebRequest; Response: TWebResponse; var Handled: Boolean); var lWebRequest: TrsWebRequest; lSession: TrsWebSession; begin {use the incoming request parameters to create a Full Article…
IIS User Accounts
RB WebTier and IIS User Accounts Question: “I am trying to configure and test the RB WebTier using IIS. When I try to test the web tier via my web browser an Internal Server 500 Error page is displayed.” Answer: This is generic error page returned by IIS. One cause of this error is that Full Article…
How To…Determine Web SessionID
Question “How can I determine the SessionID for each web request?” Solution The following example shows how to use the webTier and WebSessionManager to determine the SessionID for each request. Download: WebTierSessionID.zip Sample Delphi code: uses rsWebRequest, rsWebSessionManager; procedure TWebModule1.WebModule1WebActionItem1Action(Sender: TObject; Request: TWebRequest; Response: TWebResponse; var Handled: Boolean); var lWebRequest: TrsWebRequest; begin // create a Full Article…
How To…Deploy to IIS7
Question “How can I deploy the WebTier to IIS7?” Deploying the WebTier to IIS7+ The following is a supplement to the Server Edition Developer’s Guide, installed to …RBServer\Developer’s Guide\RBServer.pdf. IIS 7 security is tighter than prior versions of IIS. By default ISAPI modules are /not/ permited to run. Use the following steps to configure IIS Full Article…
How To…Deploy to IIS6
Question “How can I deploy the WebTier to IIS6?” Deploying the WebTier to IIS6 The following is a supplement to the Server Edition Developer’s Guide, installed to …RBServer\Developer’s Guide\RBServer.pdf. IIS 6 security is tighter than prior versions of IIS. By default ISAPI modules are /not/ permited to run. Use the following steps to configure IIS Full Article…