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

How to use SQL functions in FastReport.Net

August 14, 2018

Author - Dmitriy Fedyashov

To obtain data in MS SQL, you can use sql queries, stored procedures, and stored functions. We have already discussed how to use dynamic queries and stored procedures as a report data source. In this article, we will create a table and scalar function and use them in the report. I recall that table...

Updated Export menu FastReport.Net report

August 13, 2018

Author - Dmitriy Fedyashov

In the version of FastReport.Net 2018.3.14 appeared useful refinement that does not relate to the functionality of generator. However, it significantly improves usability report designer, or rather the report preview mode. Finishing touched menu exports. Because developers regularly delight us with...

Vector barcodes and SVG in PDF, HTML and SVG export

May 30, 2018

Author - Dmitriy Fedyashov

FastReport 2018.2 has support for vector graphics in exports. Now some barcodes and SVG images are exported in vector form. This applies to exports to PDF, HTML and SVG. As for barcodes, the explanation is needed to be given - only linear bar codes can be exported as vector images. In the current ...

How to use the new TextObject.TextRenderType property

May 29, 2018

Author - Dmitriy Fedyashov

The new property came to replace the obsolete HtmlTags. Now the TextRenderType property is responsible for processing html tags, and not only. This property has three possible values: Default – just text, without any tag transformations; HtmlTags – applying html tags. Their list is r...

How to connect to MS SQL from reports in .Net Core

May 29, 2018

Author - Dmitriy Fedyashov

One of the most common DBMS with which .Net developers work is MS SQL Server. In this article, we'll look at the way to use FastReport.Net reports in your .Net Core application with a connection to the MS SQL data source. Firstly, you need to create a report with connection to MS SQL in the report ...

Overview of new features of Online Designer in version 2018.2

May 29, 2018

Author - Dmitriy Fedyashov

The new version of Online Designer has acquired five innovations. These innovations have touched both usability and functionality. But first things first. 1. The possibility of horizontal band resizing has been added. This feature allows you to change the width of the band headers. When can it be ...