Window functions are what every T-SQL programmer should know. Part 2.
Author - Dmitriy Fedyashov
In the second part of the article we will talk about the functions themselves, which are used to form values. The window function calculates the value from a set of data associated with the current row, that is, data from the same group, if Partition by is used. Conventional aggregate functions for ...
Window functions are what every T-SQL programmer should know. Part 1.
Author - Dmitriy Fedyashov
Long time ago an interesting functionality appeared in Microsoft SQL Server 2005- window functions. These functions allow you to perform calculations in a given range of lines within a Select clause. For those who have not encountered these functions, the question arises - “What does window me...
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...