How to work with ClickHouse in FastReport Cloud

2023-11-20

ClickHouse is a popular database that is convenient for data analysis. In this article, you will learn how to connect to this database from the FastReport Cloud service for report generation and storage.

As an example, the article will use a database of tutorials on working with ClickHouse.

Database screenshot

In our case, “default” is the name of the database, and “my first table” is the name of the table. To add our database as a data source, select “ClickHouse” when adding a source. You will see the dialog:

Adding ClickHouse connection

We don’t need the table name now, just the database name. So, let’s fill out the form:

Completed form for adding a connection

As you can see from the dialog, the connection test was successful. Now just click “Connect,” and the connection will be saved among the existing ones.

Connecting to ClickHouse in the data sources menu

You can then use this connection in your reports. Now let’s try to make a simple report based on this connection:

Online designer with an open report

And, of course, take a look at the report preview:

Preview of the report with ClickHouse data

If we compare the data from the original table with our report, it will be quite obvious that the connection is functioning properly.

August 12, 2024

How to build and install the Postgres plugin in FastReport .NET

This article describes how to connect to the database using the FastReport .NET plugin for the report designer from Visual Studio via the NuGet server.
August 08, 2024

How to install FastReport .NET and its components on Windows

Step-by-step instructions for online and manual installation via the FastReport registration code.NET and its components in Windows.
July 26, 2024

Updating HTMLObject as a plugin for FastReport .NET

Detailed instructions for using the new HTMLObject plugin, which uses splitting DOM HTML into FastReport report objects.
Fast Reports
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314

© 1998-2024 Fast Reports Inc.