Forgot password?
  • Home
  • /
  • White Papers


Recursion in MS SQL

10 gennaio 2019

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

09 gennaio 2019

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

09 gennaio 2019

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.

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

06 dicembre 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

05 novembre 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 agosto 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 agosto 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 agosto 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 agosto 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...