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.

FastReport Cloud Data Source
April 22, 2025

Working with the TfrShellTreeView Component in FastReport VCL

In this article, we will look at the TfrShellTreeView component. It is designed to display file system elements and is partially analogous to the TDirectoryListBox, TDirectoryOutline, and TShellTreeView components.
April 21, 2025

How RFID Tags Work in FastReport VCL

In this article, we'll check out how RFID tags work with the new TfrxDeviceCommand object in FastReport VCL with release 2025.2.
April 08, 2025

How to Set Up a Connection to Apache Ignite in FastReport .NET

In this article, we will explore how to configure a connection to Apache Ignite in FastReport .NET. You will learn the necessary steps to connect the plugin via code and the report designer.
Fast Reports
  • 800-985-8986 (English, US)
  • +31 97 01025-8466 (English, EU)
  • +49 30 56837-3928 (German, DE)
  • +55 19 98147-8148 (Portuguese, BR)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2025 Fast Reports Inc.