• Home
  • /
  • White Papers


Window functions are what every T-SQL programmer should know. Part 2.

9 december 2018

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.

6 december 2018

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...

Manage the size of the band in the designer with the mouse

5 november 2018

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...

Installation FastReport.Mono on CentOS7

14 augustus 2018

Author - 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

14 augustus 2018

Author - 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

14 augustus 2018

Author - 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

14 augustus 2018

Author - 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

13 augustus 2018

Author - 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

30 mei 2018

Author - 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

29 mei 2018

Author - 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...