Cómo enviar un informe por e-mail desde una base de datos en la aplicación .Net Core
Author - Dmitriy Fedyashov
Cómo enviar un informe por e-mail desde una base de datos en la aplicación .Net Core Ya hemos hablado de cómo se manda un informe a un grupo de direciones de e-mail desde la base de datos. En este artículo seguimos con el tema pero esta vez vamos a tratarlo en referencia...
Cómo trabajar con Designer y eViewer desde la línea de comandos
Author - Dmitriy Fedyashov
Además de las bibliotecas mismas, FastReport.Net también incluye programas separados, Designer 'diseñador' y Viewer 'visualizador'. El primero, como es fácil de adivinar, está destinado a crear y corregir modelos de informe. Tiene modo vista previa con el que pu...
Cómo repetir la cabecera de la tabla en cada página
Author - Dmitriy Fedyashov
Si muestra un informe en diferentes páginas, puede querer mostrar la cabecera de página en todas las páginas. Esto evitará que el usario del informe pase constantemente a la primera página para comprender el propósito de las columnas y reducirá errore...
Cómo repartir informes por correo desde la base de datos de una aplicación WinForms
Author - Dmitriy Fedyashov
Los informes son una parte integral del flujo de trabajo y los informes electrónicos, del flujo de trabajo electrónico. Uno de los mecanismos principales para repartir informes electrónicos es através del correo electrónico. Quizás todos los generadores de i...
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...