How to send a report to Email from a database in .Net Core application
Author - Dmitriy Fedyashov
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...
How to work with the report designer and viewer from the command line
Author - Dmitriy Fedyashov
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...
How to make the table header repeat on each page
Author - Dmitriy Fedyashov
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...
How to make the mailing of the report to Email from the database in a WinForms application
Author - Dmitriy Fedyashov
Reports are an integral part of the workflow, and electronic reports - electronic workflow. One of the main mechanisms for distributing electronic reports is e-mail. Perhaps, all modern report generators have a built-in mail client to be able to send a report directly from the program. FastReport.N...
Report export in FastReport.OpenSource
Author - Dmitriy Fedyashov
FastReport.OpenSource has gained a lot of interest among many developers. This is a great report generator with a long history. The open source version is FastReport.Core, which appeared at the beginning of 2018, but with some restrictions. Namely - curtailed exports. Thus, only the following format...
How to create QR code with a picture
Author - Dmitriy Fedyashov
It's no longer a novelty to see a pixel QR barcode on the product packaging. Although it is more complicated than a regular bar code with stripes and it is undoubtedly more reliable. The technology of QR codes contains redundancy (duplication of information) and a checksum. Therefore, even with 30 p...
How to make columns highlighting, depending on the value of the column
Author - Dmitriy Fedyashov
Matrix reports are a great tool for analyzing data. In essence, the matrix in analytical reports is a summary table. "Conditional allocation” is often used to facilitate the analysis. This is a regular tool in FastReport.Net. Conditional highlighting implies highlighting the data cells with co...
How to use FastReport.Core in the Web API application
Author - Dmitriy Fedyashov
In this article, we will create an API for receiving FastReport reports from the server. First of all, let's define what the API is. Literally, this abbreviation stands for software interface of the application. This means that the application has an interface that provides access to its functions. ...
Handling the “Division by Zero” exception in FastReport.Net 2018.4
Author - Dmitriy Fedyashov
Among the updates in FastReport 2018.4, there was a solution to the dividing by zero error. Previously, report developers had to handle this exception themselves. After all, we cannot guarantee that because of the data this error will not occur. If you have not done the division by zero processing, ...
Displaying a prepared report on the Web
Author - Dmitriy Fedyashov
Innovations in FastReport.Net 2018.4 touched the web reports as well. Now you can display reports in fpx format, i.e. pre-prepared reports. The fpx format is very convenient for exchanging reports, because it contains data in addition to the template. Therefore, to display a report in fpx format, yo...
Scale management when printing in Excel
Author - Dmitriy Fedyashov
FastReport.Net 2018.4 version brought quite a few innovations. One of them is the ability to set the scale of the Excel page of the document when printing in the Excel export settings. You can export the report to Excel in preview mode or from the code of the user application. Let's consider both o...
Manage the size of the band in the designer with the mouse
Author - Dmitriy Fedyashov
Most of the time when developing a report, it takes away the placement of elements on the page. Very few people manage to pick up the sizes and proportions from the first time. You always have to do a couple of test runs of the report. The new function of controlling the height of the band is desig...
Duplication or removal of pages in the preview mode of the report
Author - Dmitriy Fedyashov
In FastReport 2018.4 a very interesting feature appeared - duplication and removal of the report pages in preview mode. Let us be clear. We are talking about the pages of already built report. That is, you can select a specific report page and clone it as many times as you want, or delete the select...
How to use an online designer in a web application .Mono
Author - Dmitriy Fedyashov
Those who came across with an online designer in FastReport.Net certainly appreciated all its advantages and, working with FastReport.Mono, would like to use it in their web applications. In fact, there is nothing complicated. Today we will look at the way to create a web application in MonoDevelop ...
How to create your own total in the matrix FastReport.Net
Author - Dmitriy Fedyashov
The Matrix object in FastReport .Net performs typical tasks for displaying summary tables very well. But, when the tasks are not standard, only the report script will help us. It is in the script itself you can implement almost any requirement. As you know, the matrix has a built-in function to dis...
The way to create an ASP.Net MVC application in FastReport.Mono
Author - Dmitriy Fedyashov
First of all, for programming in C # under Linux you will need to install: • MonoDevelop - development environment under the .Mono framework; • XSP - a test web server for running ASP.Net applications; • A "battle" web server, for example, Apache. But this is if you are going to de...
The way to add a data field to a matrix row
Author - Dmitriy Fedyashov
In this article, we'll have a look at the way to create a dynamic matrix that is populated from the report's script code. The peculiarity of this matrix is that in addition to the data added from the script, we will insert the data field in the report cell using a text object. Suppose you create a ...
How to create a calculated field in a matrix from a report script FastReport .Net
Author - Dmitriy Fedyashov
Matrix reports are very popular. Typically, the matrix, or otherwise summary tables are used in the accounting and statistical reporting. Let's determine what a summary table is. A summary table is a software tool that allows you to reorganize and summarize the selected columns and rows of data in ...
How to use custom libraries with functions in the report designer
Author - Dmitriy Fedyashov
Despite the fact that so-called arsenal of built-in functions in the report designer is by no means small, sometimes still lacks some specific. Thanks to the script in the report we can easily implement the desired function. But what if this function is needed in many records? Each time to add it to...
How to add a connector to an Oracle database in the report designer using the plug-in
Author - Dmitriy Fedyashov
Perhaps you have never used plug-ins for the report designer FastReport.Net. Then this article is for you. As you know, in order to display data from the database in the report, you need to create a connection to the data source. You can do this in the code of the user application or within the repo...