Forgot password?


How to send a report to Email from a database in .Net Core application

March 8, 2019

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

March 8, 2019

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

March 7, 2019

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

March 7, 2019

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...

How to create QR code with a picture

January 9, 2019

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

January 9, 2019

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...

Handling the “Division by Zero” exception in FastReport.Net 2018.4

November 5, 2018

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, ...

Scale management when printing in Excel

November 5, 2018

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

November 5, 2018

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

November 1, 2018

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 create your own total in the matrix FastReport.Net

October 8, 2018

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 add a data field to a matrix row

October 8, 2018

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

October 7, 2018

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 ...

What is yield return?

October 6, 2018

Author - Dmitriy Fedyashov

The yield return operator is one of the least known among programmers using C#. At least among beginners. And even those who know something about it, are not completely sure that they understand the principle of its work correctly. This annoying gap must be corrected. And, I hope this article will h...

Foreach in C #

October 6, 2018

Author - Dmitriy Fedyashov

Today I would like to talk about the way the foreach loop works inside. We all know that a foreach loop is - a loop that iterates through all the elements of the collection. Its greatest advantage in the ease of use - we do not need to worry about how many elements in the collection. However, many ...

How to use custom libraries with functions in the report designer

September 6, 2018

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

September 6, 2018

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...

How to manage the indentation on top of the second page of the report

September 6, 2018

Author - Dmitriy Fedyashov

Often, when the report is displayed, you can observe how the data that does not fit on the first page is transferred to the second one. This is typical for the band "Data" and "Group header", and associated with them. The Data band can contain data fields, or other objects, such as a table or mat...

How to use stored procedures in FastReport.Net

August 14, 2018

Author - Dmitriy Fedyashov

In this article we will discuss the use of stored procedures to retrieve data for a report. Using the MS SQL example, I'll show you how to create and use functions in a report. As you know, Transact SQL allows us to create stored procedures and functions. Stored procedures are used to automate any ...

How to use dynamic queries in FastReport.Net

August 14, 2018

Author - Dmitriy Fedyashov

Most users of FastReport.Net build reports receiving data from SQL DBMS, and would like to take advantage of Sql in their reports. Nothing prevents you from using dynamic queries, stored procedures and functions. In this article, we will have a look at how to use dynamic queries when creating a repo...