How to send a report to Email from a database in .Net Core application
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
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
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
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...
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...