We continue to develop new FastReport .NET functions. Our team is increasingly expanding the features of our library for generating reports. With a recent update, we have added the function of connecting to MsSQL stored procedures. These stored procedures are a set of instructions that are execut...
Data Source
Our FastReport .NET offers rich features and wide functionality. Today we will look at how to connect to a database through the FastReport plugin for the report designer. This plugin is based on the Npsql.dll library. First, let's figure out how to build the right plugin for FastReport .NET. Aft...
We are pleased to present you a new plug-in for configuring а connection to Cassandra, which is available for FastReport .NET, FastReport Core, FastReport CoreWin, FastReport OpenSource. Let’s note an important detail that the order of the records will be overset because of the CassandraCsD...
With a great variety of document formats, often can be a situation when the customer wants to use some kind of document formats they already have and don't waste time on creating the same layout in the report. For those cases, FastReport VCL provides the ability to use RichText or HTML tags ...
How to make a mush of data into an informative report? Oracle DB, MySQL, Microsoft SQL Server, PostgreSQL, FireBird are probably the most popular, but by no means all, of the many DBMSs in which data can be created, populated, modified and managed. Often they are filled with this very data for...
I would like to note that FastReport VCL is one of the most convenient components for generating reports of any complexity. After all, here we can use not only different types of DBMS, but also Swiss barcodes, maps, tables, graphs and many other objects. Quite often we are asked “how to create...
Probably many have encountered the problem of using a CSV file as a DataSet in Delphi. Let's have a look at one of the solutions to this problem. We will connect the CSV file via TADOQuery and build a report from this data in FastReport VCL. Create a project and add the following components. ...
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 ...
Sybase SQL Anywhere database has a number of very useful features that make it very competitive in comparison with competitors. First, it allows you to handle very large volumes of data. Secondly - it is highly productive, that is, despite the offer large volumes of data fast. Thirdly it requires mi...
First of all, you need to assemble a plug-in connector library to the database for the reporting designer. It is located in a folder: C:\Program Files (x86)\FastReports\FastReport.Net\Extras\Connections\FastReport.MongoDB Open the project, restore NuGet packets and reassemble it. As a result, in t...
The Vista database will fall into the type of embedded databases. These databases differ from client server databases in that they are designed to be embedded in a client application as a file. The range of tasks of such a base will also be different from the database. Typically, these are databases...
First of all, you can use the ODBC connector. But it is fraught with a lot of settings. As you can see, you need to create the data source and the connection string to it. Relatively a lot of action. An alternative to this method is to use connector from FastReport. In fact there are two connect...
To connect the report to a DB2 database, you need to connect the plugin to the designer reports. This plug is a connector. But first you need to collect this connector from the project: С:\Program Files (x86)\FastReports\FastReport.Net\Extras\Connections\FastReport.DB2 The resulting FastReport.DB2...
NosDB is a prominent representative of the NoSQL databases. It is designed for use on the .Net platform and has open source. NosDb, like many other non-relational databases, has a high speed and good linear scalability. In this article, we'll look at the way to connect to the NosDb database inside t...
Recently, the NoSQL database is gaining more and more popularity. They differ favourably from conventional relational databases and provide the following: high resilience, incredibly large amounts of data, good scalability, clustering. One of the new NoSQL databases is RavenDB. This is a document-o...
Microsoft SQL Server Compact Edition is a simple local relational database that doesn't require installation, and the connection is made to the database file. You do not need admin rights to work with the base. You can only "password" the base. For many developers, such a simple database is simply n...
FastReport .NET provides a plugin mechanism for extending the functionality of the report designer. Most of these plug-ins are for adding database connectors in the report designer. But there are others. For example, those which add new controls to the designer. But before using plugins, you must f...
Despite the fact that FastReport.Net provides us with a plugin for the report designer to use as a data source for the JSON file, it is not always suitable. This plugin works well with single-level data representing a separate table. In cases where the data has multiple levels of nesting, you will h...
Perhaps you have never used plug-ins for the report designer FastReport .NET. Then this article is for you. As you know, in order to display data from the database in the report, you need to create a connection to the data source. You can do this in the code of the user application or within the ...