Types of solutions for generating reports and documents

Friends, this year has been eventful and productive for us! 📌 Key achievements Release of new products: we launched FastReport Avalonia – a tool for cross-platform work on reports for Windows, MacOS, and Linux. Changes in approach to product formation: we split the product content in a way where you do not have to buy unnecessary functionality. What changed for our products? For Delphi and Lazarus: Improved work with hierarchical data in FastReport for Delphi and Lazarus by adding the TfrTreeView component. Additional capabilities for working with maps were added by supporting the GeoJSON and TopoJSON formats. Improved digital signatures, added infinite table width, expanded barcode capabilities, and improved display accuracy and compatibility of PDF, HTML5, SVG, DOCX, and XLSX export filters. In the latest version, we have enhanced the capabilities of working with reports in complex scenarios and provided a higher level of integration with modern development environments, including RAD Studio 12.2. Next year, we plan to add new components, support for RFID tag EPC in ZPL, new transports, improved export filters, and much more. For .NET: We have abandoned the legacy .NET Standard 2.0 - 3.1 and .NET 5 compatibility layer in our libraries. Now the minimum supported .NET version is .NET 6, and the minimum supported framework is .NET Framework 4.6.2. With the latest version of the FastReport .NET library, FastReport Business Graphics .NET and FastCube .NET now support .NET 9. To do this, we abandoned binary serialization (BinaryFormatter). This year, we relaunched FastCube .NET, a library for working with OLAP cubes and operational analysis of big data. Now FastCube.Core.Web supports  Linux and MacOS. It opens up the possibility of developing web applications with OLAP functionality on any server. One of the key changes in the FastCube .NET 2025.1 release was the complete removal of the dependency on the System.Drawing.Common library in the FastCube.Core module. This was done to increase the library compatibility with various platforms and improve performance. The FastReport Online Designer visual template designer has also changed. In 2024, a new "SparkGraphic" object was added, it became possible to create guidelines on the page and a new component menu was implemented. When editing the report code, the Intellisense functionality was added, which provides automatic code completion and syntax hints, which allows users to write code faster and more accurately directly in the web interface. In 2025, we plan to add a new plugin allowing you to convert user reports from MS Word to .frx. In addition, a connection to Google Sheets will be implemented in the future. FastScript .NET for executing scripts will be released in the first half of the year. The new library will contain a compilation technology that allows you to convert intermediate code into machine code for a specific platform (Native AOT). We are striving to create a complete ecosystem of products for different platforms, so next year we will also work on their integration with each other. For service solutions: In FastReport Cloud, we improved the automatic task execution system, added printing from the browser, and developed a font storage, finalized the SDK. Improved the usability and speed of the API Added new API methods for working with the cloud, allowing you to perform familiar operations faster and more conveniently: bulk copying, deleting, and moving files; a new upload method that allows you to upload large files and use fewer resources; methods for obtaining the current user's rights to files, groups, tasks, and data sources; added the ability to receive and edit report parameters without opening the report itself for editing. Made the user panel more convenient Improved work with the Online Designer: added a Richtext preview, and style templates for ChartObject. Gave the ability to edit the user's avatar, made a new trash bin for deleting files, improved the Tasks page; finalized data sources, giving the ability to use stored procedures and add custom tables from SQL. In 2025, we plan to release a new product and add parameter transfer to StaticPreview UI.   We thank you for trusting us in 2024. Let's move on and create the future together! Happy Holidays!  

From December 18 to December 31, we are offering you to purchase reporting libraries for .NET and Delphi at a 25% discount. This is a great opportunity to make sure that in 2025 your business will save resources on creating documents and reports. The offer does not apply to renewals and upgrades. Only new purchases are eligible. BUY NOW

Introduction What is FastReport .NET? FastReport is a flexible and powerful reporting tool. It allows users to access data sources in various formats and present them visually. Reports created with FastReport can be easily designed using drag-and-drop logic in the user interface and converted to different formats (PDF, Excel, Word, etc.). FastReport's Role in Reporting Solutions Reporting is a critical need in data-driven applications. FastReport allows users to visualize and analyze their data. Suitable for both desktop and web applications, this tool provides fast results with minimal coding. Advantages of Integration with .NET FastReport works perfectly with .NET applications. When integrated with the powerful development ecosystem offered by .NET, report creation processes can be automated, dynamic reports can be generated, and large data sets can be processed quickly. Additionally, using the flexibility offered by .NET, it is easy to integrate reports with the rest of your application. Purpose of the Blog This article aims to explain step by step how to install FastReport on .NET 8.0 and how to create a simple report. Taking the reporting process from the beginning, it will show how to connect, design, and view reports.     1. FastReport Installation 1.1. Requirements Before you begin, you need to make sure the following requirements are met: .NET 8.0 Requirements: Make sure your project is running on .NET 8.0 platform. To install .NET SDK, download the latest version from Microsoft's official site. IDE: You may be using Visual Studio, JetBrains Rider, or another IDE. Check that .NET 8.0 support is enabled in Visual Studio. 1.2. Adding the FastReport NuGet Package The easiest way to add FastReport to a project is to use the NuGet package manager. NuGet Package Manager with Visual Studio: Right-click on your project and select Manage NuGet Packages. Type FastReport in the search box and select the FastReport.OpenSource package from the results. Click the Install button and wait until the package installation is completed. Command Line Installation: If you prefer the command line, you can add FastReport to the project with the following command: Install-Package FastReport.OpenSource This will include the latest version of FastReport in your project.   1.3. Licensing and Activation  To start using FastReport, it is important to follow the licensing steps correctly: Free Version: Although the free version of FastReport offers some basic reporting features, the full version is required for more advanced features.  Licensing: If you want to use the full version, you can purchase a license from FastReport. After you receive the license key, you can activate the program by entering your license key from the FastReport activation window.  Note: The free version has some limitations, for example, the full list of export formats may not be available. Replacing part of the report content with the text "Demo version" randomly. The label "Demo version" on the report pages when printing and exporting. Since I will explain the reporting tool using the trial version in this article, I downloaded the program from the FastReport installation link. You can proceed directly as the welcome screen provides convenience for automatic installation. Once the user agreement is approved, you can continue the process. Here we mark which type of source we will use. For this article, I will only use .NET Trial.  After the installation is completed, the application is ready to use. 1.4 FastReport.OpenSource FastReport is renowned for its powerful, professional-grade reporting tools and offers two main options based on users' needs: a commercial version and FastReport.OpenSource. FastReport.OpenSource is an ideal choice for developers seeking a fast, cost-free, and customizable reporting solution in small to medium-scale projects. Its open-source nature grants users complete control over the code, enabling them to make in-depth customizations tailored to specific project requirements. FastReport.OpenSource includes many core functions of reporting tools: it allows you to design reports, create data connections, visualize data, and generate report outputs efficiently and quickly. For small-scale projects or budget-constrained initiatives, its open-source format offers access to powerful reporting capabilities without licensing fees. Additionally, its community-driven structure provides developers with a continuously growing pool of resources and up-to-date knowledge. 1.5 Customization and Development Capabilities With FastReport.OpenSource’s open-source structure, developers can create tailored customizations suited to their projects. This flexibility allows you to build custom report formats or make specific adjustments to existing features. The ability to customize gives developers the advantage of aligning reports with the functional and visual requirements of their projects. 1.6 Community Support and Resources One of the key advantages of FastReport.OpenSource is its strong community support. Along with the source code accessible on GitHub, users share their experiences and developments, creating a constant flow of insights. Community support is highly beneficial for troubleshooting and generating new ideas. FastReport’s development team also provides regular updates, ensuring the platform continues to evolve. 1.7 Use Cases FastReport.OpenSource is an excellent solution for educational projects, personal applications, or startup projects. It is particularly suitable for projects that require essential reporting capabilities, such as financial statements, customer reports, inventory lists, and analysis reports. Its open-source nature makes it fully customizable and adaptable to meet the needs of your specific project.     2. Creating a Simple Report 2.1. Using FastReport Designer FastReport Designer is a visual tool that simplifies report design. Introduction to FastReport Designer Interface: FastReport Designer provides a drag-and-drop user interface to design your report. You can easily add components such as data tables, charts, text boxes, etc. to your report. Adding Data Sources: As a first step, you need to add the data sources that you will connect to your report. These sources can be in various formats, such as SQL databases, JSON files, XML format, etc. In FastReport Designer, you can easily define these data sources and include them in your report. After opening a blank report design, you can connect your database here by selecting New Data Source from the Actions box. FastReport does not require us to use only MS SQL. If you wish, you can define your data in formats such as JSON and XML and create your reports. You can flexibly use all the options in your database during import. In addition to tables, procedures and views can also be imported into FastReport and used in reports. 2.2. Report Layout Design Creating a Simple Table Report: When you start designing a report, you can use the table component to show your data. In this sample application, I will create a simple report using information such as age, name, etc. in a table containing company personnel. Adding Headers, Data Fields, and Footers: Make your report more readable by adding header rows to the table. Connect data fields with data from the data source. You can add additional information such as totals and page numbers to the footer rows. Style and Formatting Options: You can use style and formatting options to make your report look more visually professional. For example, you can make headings bold and change the color of data cells. In a simple design, after adding the data source, the entire report can be created by adding only text. In the modal where the texts to be added are opened, there are System Variables and Data Source variables for convenience. By selecting these, the entire report can be created with the drag-and-drop feature. 2.3. Preview the Report Running the Report and Viewing it in Preview Mode: After you design your report, you can run it in preview mode to see if the design looks right. In this mode, you can view your report in different formats and fix any errors. You can see a preview of the report you are working on via File-Preview or Report-Preview. Exporting the Report in Different Formats: FastReport allows you to export reports in different formats such as PDF, Excel, and Word. You can use the “Save” button in preview mode to convert your report to the desired format.     3. .NET Code Integration and Calling the Report from the Application 3.1. Calling a Report with a DB Connection After saving the report we just created as .frx, we can transfer it to our .net project as a file and call the report from this file. In reports prepared with a mssql db connection, you must install the "FastReport.Data.Mssql" package. We are ready to call the report we just prepared from the project. We save our frx file via FastReport and add it to our “BasicFastReportDotnet8” project, which we opened as a .net8 console app. The packages we will use in this operation are: FastReport FastReport.Data FastReport.Export.Image Let's open our .frx extension file and take a look; In fact, we can almost update the report from here. The elements we use in the file are presented in XML format and our data source connections are nicely defined. Great! Now, since we used mssql connection in this report, we need to go and specify it: In this way, we indicate that the report has ready data and there is no need for a preparation process. The rest is child's play! First, create a new report instance and create our report object. Then load the frx file prepared into the relevant report. Give the command to prepare the report. And finally, decide in which format we will save it. Yep, that's all! Let's see how our report turned out:   3.2. Calling Simple Report Template by Feeding Data from Application These operations can also be performed using an empty template. We can repeat the same operation with the desired objects by giving the "report.RegisterData" command to the report object just before the prepared operation.     Conclusion Fast and Efficient Reporting with FastReport FastReport offers a fast and effective reporting solution for both small projects and large-scale applications. Thanks to its user-friendly interface and .NET integration, report design and management can be easily performed. In addition, being able to pull records from the DB at any time increases the speed of report analysis by separating server-side and DB operations. Advantages of FastReport Seamless integration with .NET applications, multiple data source support, and flexible design options make FastReport an attractive choice. Advice on Exploring Advanced Features To explore FastReport’s advanced features, you can browse its official documentation and work with templates, charts, and more complex reporting techniques. Using a Private NuGet Server If you’re using the commercial version of FastReport, you can set up a private NuGet server to access FastReport packages specifically for internal or private projects. This method is especially useful for corporate users who need to maintain control over access management and updates. The flexibility FastReport offers allows you to access NuGet packages in a more secure and manageable way. For more details, refer to the Private NuGet Server Setup article.   The article is written by Liubou Patskevich from Softacom.

In today's world, the ability to provide your software to customers around the globe is of great importance. Therefore, FastReport VCL supports about 40 of the most widely spoken languages for localizing the user interface.  Starting from version 2023.2, the localization mechanism in FastReport VCL has been significantly improved — it is no longer necessary to recompile in order to translate FastReport into other languages. The localization package is included in all FastReport VCL delivery kits. Localization is performed "on the fly" by selecting the desired language in the Report Designer from the "View — Language" menu. Moreover, you can manage the interface language of FastReport VCL directly from the code!     Checking and Installing Localization Packages  For localization to work correctly, it is necessary for the IDE to have the localization packages (frxLanguageXXX) and the localization controller package (frLocalization) installed. In the Windows operating system, localization packages are automatically installed for the Delphi and Lazarus IDEs. If the localization menu is not available, you need to check if these packages are installed in the IDE. In Delphi, you will see the following window: The localization menu in Lazarus looks as follows:   If any of the translation packages are not required, they can be removed from the development environment.     Working with TfrLocalizationController and Language Selection As mentioned earlier, changing the language in FastReport within the report designer is very simple. Go to the "View — Languages" menu and choose the desired language. To connect FastReport localization to the application, you need to use the TfrLocalizationController component. Simply place it on the main form of the application. Next, for Delphi, right-click on the component, and then in the dropdown menu, select the language that you need FastReport to support in your program:   After this, you need to select the language for the TfrLocalizationController component that will be loaded by default when the application starts. You can also add the module containing the necessary localization to the uses section of the main form. It should be noted that by default, FastReport VCL uses the English language, so if you only need English, there is nothing else to do. To connect localization in Lazarus, you need to add the language package to the project and then add the module for that language.     Changing Language from Code In some situations, it may be necessary to manage FastReport VCL localization from the program code. This is done as follows:   frLocalizationController.Language := ‘German’; The following code sets the language to German. Do not forget that your program must be compiled with the language package you wish to switch to. You can find out which language packages the program is compiled with using the code below. To do this, you need to include the Types module, place TButton and TMemo components on the form, and write in the Button.OnClick event handler: procedure TForm1.Button1Click(Sender: TObject);var D:TStringDynArray; I: Integer;begin  Memo1.Lines.Add('Default Lang: '+TfrAvailableLanguagesController.GetDefaultLanguageName);  Memo1.Lines.Add('Current Lng: '+frLocalizationController1.Language);  Memo1.Lines.Add('Suppotred languages:');  D:=TfrAvailableLanguagesController.GetLanguages;  for I:=Low(D) to High(D) do begin    Memo1.Lines.Add(D[I]);  End;end;    Please note that the English language is not included in the list of supported languages, but it is always available by default.     Editing Localization via the Localizer You can open the Localization Editor as follows:   In the Delphi IDE, go to the menu "Tools… - Localization Editor…"   In Lazarus, navigate to the menu "Services - Localization Editor…" You can invoke the "Localization Editor" from your program using the code below. However, this method is not available in all versions.   frLocalizationController1.ShowLocalizationEditor; Purpose of controls in the localization editor: open the *.xml file with translation save the *.xml file with translation save the translation file with a specified name  undo the last action   redo the undone action   set the translation language filter records by mask   clear the filter   show only translated records show only untranslated records   The “Localization Editor” allows you to translate FastReport VCL resources into various languages line by line. In the center of the editor is a grid with the translatable values.   The first column displays the identifier of the element that is to be translated. It is always a string, even though some rows may contain numbers, as their string representation is used. The second column shows the original value of the element in English. The third column contains the translated value of the element for another language. Let's move on to the principle of how the localization editor works. Upon loading, the editor checks which localizations are available to the application it is embedded in. It then populates the list of available languages (a combo box for entering the target language). The currently set localization is active for editing. You can choose and edit the translation for any of the available languages and save it to an XML file. If you already have an XML file with translations, you can load it for editing. In the localization editor, you can switch between display modes. For example, you can show only those elements whose translation matches the original in English, or conversely, show only those elements whose translations differ from the English version. However, it should be noted that not all elements need to be translated. You can apply a filter to the entries in the grid. A grid element is displayed only if the filter value exists in any column. You can also sort the grid in both ascending and descending alphabetical order by clicking on the header of any column. If you have modified the translation file, you can connect it to the application instead of the standard one. To do this, you need to include the frResources module in the uses clause using the following code:   frStringResources.LoadFromFile('mylanguage.xml'); We recommend restarting your application after editing files for the correct display of all translated resources. It should also be taken into account that the loaded translation immediately becomes active but will only work until the first switch of the language. Upon switching back to that same language, the localization will be pulled from the resources connected to the program. Additionally, you can compile the resource with the translation file yourself. Place it in the directory with the corresponding language module and use it in your program. To have this translation appear in the IDE, run the installer and select the Recompile mode, or simply recompile the package for the language you need. In Lazarus, you will need to rebuild the IDE afterward; in Delphi, you will need to restart the environment. If you want your translation to be retained after each update, you can send the localization file to us at support@fast-report.com. We will review the received file and add it to the installer.