Connection to SQLite DB from a report

August 17, 2017

Author - Dmitriy Fedyashov

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

Connecting to PostgreSQL DB from the report

August 17, 2017

Author - Dmitriy Fedyashov

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

Connecting to MySQL DB from the report

August 15, 2017

Author - Dmitriy Fedyashov

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

How to create Master - Detail report from unrelated tables

March 27, 2017

Author - Dmitriy Fedyashov

How to create Master - Detail report from unrelated tables 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 re...

How to register data sources in web reports FastReport.Net

March 16, 2017

Author - Dmitriy Fedyashov

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

How to use data in JSON format

February 15, 2017

Author - Dmitriy Fedyashov

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