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...
How to manage the indentation on top of the second page of the report
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...
FastReport .Mono. What is it? What for is it?
Author - Dmitriy Fedyashov
Mono is an open source development platform based on the .NET Framework, allowing developers to create cross-platform applications. The implementation of Mono .NET is based on the ECMA standards for C # and Common Language Infrastructure. Initially, Mono was developed by Novell, then it was develop...
Installation FastReport.Mono on CentOS7
Author - Dmitriy Fedyashov
As you know, installing programs on Linux systems is traditionally done using the command line from the repository. However, now many systems provide visual software repositories, for example, Ubuntu Software Center. But we will consider the first method. To work with the report generator FastReport...
How to use stored procedures in FastReport.Net
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
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
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
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...