Microsoft SQL Server Compact Edition is a simple local relational database that doesn't require installation, and the connection is made to the database file. You do not need admin rights to work with the base. You can only "password" the base. For many developers, such a simple database is simply n...
Until recently, the export of multi-page reports in Excel format was done on one sheet. That is, all pages of the report were displayed on one sheet in Excel. Of course, this is not always convenient; it would be better to be able to display each page of the report on a separate sheet in an Excel do...
With this Easter egg, FastReport developers decided to show us an alternative way to use their generator. Based on the report, they created a game - the well-known Minesweeper. Surprisingly, this is indeed possible thanks to the built-in report script. However, this is not just a report from the dem...
Sometimes it is required to display the same information several times in a report. This may be required in reports that will be printed, for example, invoices, business cards, announcements, invitations, and others. This was not a trivial task before. You had to use a report script to “multi...
Reports with grouping are necessary for data analysis. But when there are a lot of data and there is no need to display them all, a regular report with grouping becomes cumbersome and redundant. You want to find a universal solution for such cases. And there is one. A report with a drop-down list i...
The variety of electronic documentation sometimes seems to be limitless. However, in practice, not many types of documents are commonly used. In electronic reporting, the most common type of document is a simple list. Then, there go complex lists. There can be many variations of complex lists, but ...
FastReport .NET provides a plugin mechanism for extending the functionality of the report designer. Most of these plug-ins are for adding database connectors in the report designer. But there are others. For example, those which add new controls to the designer. But before using plugins, you must f...
When creating a SQL database connection, you can specify a query to select filtered or combined data. The standard tools of the data source creation wizard also allow you to include parameters in the SQL query. In this case, the designation of the parameter will depend on the type of DBMS to which t...
The framework Vue.js is now very popular and is on a par with Angular. We have already considered the way to use FastReport.Core in the Angular application,. Now let's see how to implement the display of the FastReport web report in a one-page application on Vue.js with a backend on ASP .NET Core. ...
While working with FastReports online report designer, we usually have to upload our report templates into it, and then, after editing, download them. Today we will look at how this can be done in the context of an ASP .NET Core application. Create an ASP .NET Core application. Add the FastReport ....
The knockout.js library was quite popular among web developers before the appearance of angular. Despite the obvious advantages of angular, knockout is still in demand. Many web applications are written on it. Some of them need reporting. Therefore, we will discuss in this article how to integrate t...
In the first part of the article we reviewed the innovations of FastReport.Net 2019.4 in terms of vector graphics. Now polylines and polygons can be constructed by Bezier curves. In this article, we will consider the possibility of creating curves using a report script. Currently there are two ways...
Electronic document management has become an integral part of our lives already long time ago. Everyone appreciated the convenience of such documents - they do not deteriorate over time, they are more difficult to lose, easy to store and quickly transfer to any distance. And although, the times of r...
Back in FastReport .NET 2018, entry-level vector graphics appeared in the reports. These were polygons and curves. It was possible to build complex shapes, but all the curves were straight. In version 2019, Bezier curves finally appeared - and therefore, full-fledged vector graphics. Now we can crea...
Despite the fact that FastReport.Net provides us with a plugin for the report designer to use as a data source for the JSON file, it is not always suitable. This plugin works well with single-level data representing a separate table. In cases where the data has multiple levels of nesting, you will h...
The Knockout.js library is used to create web applications. Due to the support of this library in Microsoft Visual Studio, we can use TypeScript and backend based on ASP .NET Core MVC. The last means that we will be able to use FastReport .NET reports. It remains only to display the report in the cl...
Sometimes, we have to deal with data from different sources, in different formats. This can be a real headache for analysts and report developers. After all, you have to somehow combine the data. Fortunately, in the reports of FastReport .NET you can create many data connections. Moreover, data sour...
We have already discussed how to send a report to a group of emails from the database. In this article we will do the same, but for a web application on the .NET Core MVC platform. Let me remind you that our task is to get a list of email addresses and user names from a certain database and, send em...
In addition to the libraries themselves, FastReport.Net also includes separate programs - Designer and Viewer. The first one, as you understand, is intended for creating and editing report templates. It has a report preview mode from which you can view the report, export it to the desired data form...
When you display a report on several pages, you will most likely want to display the table headers on each page. This will prevent the user of the report from constantly turning over to the first page in order to understand the purpose of the columns and reduce errors in the perception of informatio...