Connection plugin for Cassandra from FastReport .NET

2022-08-18

Connection plugin for Cassandra from FastReport .NET

We are pleased to present you a new plug-in for configuring а connection to Cassandra, which is available for FastReport .NET, FastReport Core, FastReport CoreWin, FastReport OpenSource. Let’s note an important detail that the order of the records will be overset because of the CassandraCsDriver library used by this connection.

Cassandra — is а NoSQL distributed database system, which аllows to create highly scalable and reliable storages of huge data arrays in the form of a hash.

To use it, you must first build the project:

С:\Program Files (x86)\FastReports\FastReport.Net\Extras\Core\FastReport.Data\FastReport.Data.Cassandra

After building the project, you will need to add the plugin to the application in one of two ways:

1. Add plugin via designer:

Adding a Plugin

 

2. Add the plugin as a dependency when starting the project and register it in the code with the following command:

FastReport.Utils.RegisteredObjects.AddConnection(typeof(CassandraDataConnection));

To create a connection to Cassandra, you need to click on the "Data" tab in the designer, and select the "Add Data Source" item. Click on the "New Connection" in the resulting window. Specify the database address(es), key space, port, username, and password.

If there are no problems with access to the database, then a list of tables will appear after clicking the "Next" button. When connecting a table, you must check the box to the left of the table name. It will be possible to complete the connection only after that.

Connecting to Cassandra

 

Upon connecting the data source, you need to bind a band to it.

Report template connected to Cassandra

 

The final report will use data from the created connection to Cassandra.

Prepared report with data from connection to Cassandra

 

An example of connecting to Cassandra from code:

// Create an object CassandraDataConnection
var connection = new CassandraDataConnection();
// Create an object CassandraConnectionStringBuilder
CassandraConnectionStringBuilder stringBuilder = new CassandraConnectionStringBuilder();
// Configure аn object CassandraConnectionStringBuilder
stringBuilder.ContactPoints = new string[] { "localhost" };
stringBuilder.DefaultKeyspace = "uprofile1";
// Set the connection string
connection.ConnectionString = stringBuilder.ToString();
// Initialize all tables
connection.CreateAllTables();
// Set the connection name
connection.Name = "NewConnection";
//Creаte аn object Report
var report = new Report();
// Add a connection to the report
report.Dictionary.Connections.Add(connection);
// Enаble connection display
connection.Enabled = true;
// Select a table and connect it to the report
foreach (TableDataSource table in connection.Tables)
{
 table.Enabled = true;
}

After executing this code, we can see in the designer a new connection with the "user1" table in the list of available connections.

Data source added after the code execution

 

As you can see, it is now possible to create a connection to Cassandra and use the data stored there.

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.
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.
November 27, 2023

Creating custom line styles in FastReport .NET

With DashPattern, you can set a custom pattern to create a unique style of lines of PolyLine, Polygon, LineObject, and ShapeObject
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.