FastReport.Net has been supplying plugins for a long time - connectors to various databases. These plugins allow you to add connectors to the report designer to connect to the required database. The purpose of creating these plug-in connectors is to simplify the process of connecting to a data sourc...
Data Source
FastCube .NET is powerful OLAP Engine which adds Business Intelligence to your application. Let's look how to bind data to its pivot table! Typically, the data in the OLAP cubes are loaded from the database. To fill a cube with data, you need to create a data source. And here I would like to say a...
In this article I would like to see a connection to a SQLite database from a report. We will look at this in two examples. The first - with the help of plug-in for Report Designer, the second - with the help of ODBC SQLite driver. So, to use a plugin from FastReports, you must first make it. To d...
In this article we will look at ways to connect to a PostgreSQL database from FastReport.Net report. FastReport provides a plug-in report designer that allows you to connect to Postgres. At the core of this plugin is Npsql.dll library. But first things first. First, we consider the connection to t...
It is known that FastReport.Net can work with almost any database. And quite often the users the question arises, how to connect MySQL database to your report. In this article we will look at the process inside and out, and in two versions: 1. In the first method, you can use special plugin to con...
It is often needed to create a Master-Detail report type, when the main table acts as a grouping one. One record in the main table corresponds to the number of records from the detail table. To create this report, we need to create a relationship between the tables by a key. Let us exam the proced...
To use a data source in web - reports you need to register it. This can be done in two ways that will be illustrated in this work. Registering a data source using the popup - menu of “WebReport” component. Use the project ASP.Net. Add the component “SQLDataSource” to the ...
There used to be a question “How to use JSON data to my web reports?” as it was not easy to implement it in FastReport.Net. Recently a version 2016.2 has been released to answer it and help users. It must be clarified that JSON (Java Script Object Notation) is a text data exchange form...
In order to send a data source to a report it must previously be pre-registered in the report. Then, within the report select an available source from the list and only after that - start to work. It would be great if the data source could be available to a paste when you open the report designer. B...
Sometimes with some data sources we have to create aliases for the table fields. This happens when the field names are not understood intuitively or their native language is not used in their naming. For the convenience of working with such a database, FastReport .Net allows you to create aliases. B...