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...
Recursion in MS SQL
Author - Dmitriy Fedyashov
Sometimes, a stored procedure or function is required to use the results of a sample several times. In such cases, we often use temporary tables. However, it is worth considering some advantages and disadvantages of temporary tables. Advantages: Temporary tables are full tables. Therefore, you c...
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...
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...