Forgot password?


Report export in FastReport.OpenSource

10 stycznia 2019

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

10 stycznia 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

9 stycznia 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

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

9 grudnia 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 grudnia 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 listopada 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 sierpnia 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 sierpnia 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 sierpnia 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...