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 ...
Data Source
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 fi...
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...