Search result

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 functions return tables, and scalar functions return single values. Let’s create a table function in MS SQL 1 2 3 4 ...

Often, when creating reports, we have to deal with databases that are far from ideal. The various "features", sometimes get us stuck. For example, how to build a report based on multiple datasets, which will result in MS SQL stored procedures? When you create a data source in the report, we can use a stored procedure in SQL query, but only for a specific table. This means that it will take only a first set of data returned by the stored procedure. To generate multiple tables of the results of a stored procedure, we need to create a data source software in the code of a custom application. You need to create a database connection, execute the stored procedure, and enter its results into the dataset. Then we transfer dataset to the report and record the data source in the report. In this way, in the designer we will receive the prepared data source when making the report. We can go further and programmatically connect to the report source, so it's already in the data tree. But ...

    We are having a busy-busy summer and invite you to meet us at the following events in Europe that we organized together with our partners:      Date Name ...

The Vue.js framework is currently very popular and stands in line with Angular. We have already considered how to use FastReport.Core in Angular application. Now let us consider how to implement the display of a FastReport web report in a single-page application on Vue.js with backend on ASP .NET Core. For that, we need to install Node.js and, as minimum, NET Core SDK 2.0; however, a newer version is even better. By default, dotnet sdk does not have a vue application template. But it can be installed! To do that, create a catalog, in which your application will be placed, and run the PowerShell command line in it. This can be done from the context menu, which is invoked by a right button click on the empty space in the directory with the pressed shift button. Input the command in the command line: ...

Recently many countries digitize payments. In other words, they convert existing payments to digital format. The most common way to automate payments is to use QR codes that are easily read by smartphones. The ability to encode a sufficiently large amount of information, high damage resistance, no need in special equipment to read – these are the main advantages of the QR code that made it popular all over the world. Swiss authorities also decided to use QR codes to secure electronic payments. This means that all payment receipts and bills will have these codes. In this regard, Swiss QR code support appeared in the FastReport.Net report generator and although Swiss QR is just a kind of QR code, it is used in a specific form of Swiss bill. It is quite simple and contains information about: payee, payer, invoice, payment link and amount. Let’s create a report template for a Swiss QR bill. ...

ShapeFile, also known as Shape is a figure or a set of complex shape figures (probably, unrelated). A Shape field can be one of the following types of geometry: point, polyline or polygon. It is also notable that together with a *.shp file, *.dbf file is formed and it contains the header information about our shapes. It is important that the *.dbf file has the same name as the *.shp file. The main .shp file stores geometric data indexed in a .shx file (index) and extended attributes with their values in a dBASE (.dbf). ESRI publications have a full specification of the ShapeFile format (.shp, .shx, .dbf) and use the full support among a number of GIS and CAD systems, they are widely used to represent all kinds of maps and cartographic diagram layers. If one of the files from this ...

- added Delphi 4-7, 2005, C++Builder 4-6 support- added FastReport 3 (*.fr3) format support in report designer- report preview improvements- bug fixes ...

How to register Json as a data source in FastReport.NET without knowing its schema? If you need to register Json as a data source in FastReport.NET, then you can do it through the registration of business objects. Read here   ...