Window functions are what every T-SQL programmer should know. Part 2.
Auteur - 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.
Auteur - 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...
Manage the size of the band in the designer with the mouse
Auteur - 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...
Installation FastReport.Mono on CentOS7
Auteur - 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
Auteur - 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
Auteur - 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
Auteur - 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
Auteur - 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...
Vector barcodes and SVG in PDF, HTML and SVG export
Auteur - Dmitriy Fedyashov
FastReport 2018.2 has support for vector graphics in exports. Now some barcodes and SVG images are exported in vector form. This applies to exports to PDF, HTML and SVG. As for barcodes, the explanation is needed to be given - only linear bar codes can be exported as vector images. In the current ...
How to use the new TextObject.TextRenderType property
Auteur - Dmitriy Fedyashov
The new property came to replace the obsolete HtmlTags. Now the TextRenderType property is responsible for processing html tags, and not only. This property has three possible values: Default – just text, without any tag transformations; HtmlTags – applying html tags. Their list is r...