Create Reports from PostgreSQL Datbases with List & Label

List & Label is a reporting component for software development. It allows you to add a wide range of reporting and analysis functions to your software to create reports from PostgreSQL and other databases. See how it works.

The most important facts about List & Label in a nutshell:

N

Timesaving data binding via data provider

N

Support for relational databases

N

Report Designer with interactive preview included

N

Special functions such as barcodes, PDF object, object model (DOM), ZUGFeRD, XRechnung, ...

N

Output and export to various formats

N

Database-level filtering and aggregation

N

Interactive charts, tables, and lists with drilldown and drillthrough

N

Comprehensive help: OnlineDocu, Forum, Manufacturer Support, continuous development

Analyzing data from PostgreSQL databases – how it works

Bind List & Label easily to PostgreSQL data via the included data provider. The data can be used for reporting, whether it’s stored in views, tables or table-valued functions. List & Label also supports relational databases, so that PostgreSQL data can be searched with drilldowns or drillthroughs.

reports, stats and analyzes from postgresql data

Binding PostgreSQL Databases to List & Label

The classes involved are the NpgsqlConnectionDataProvider, to retrieve the entire database, or the DbCommandSetDataProvider, to execute individual PostgreSQL commands as required. Here is a simple example…

// Part 1: Preparing the connection information for the PostgreSQL database
var builder = new NpgsqlConnectionStringBuilder();
builder.Host = Properties.Resources.HostName;
builder.Database = "Northwind";
builder.Username = Properties.Resources.Username;
builder.Password = Properties.Resources.Password;

  // Part 2: Connecting the NpgsqlConnection with the appropriate List & Label data provider
NpgsqlConnection sqlConnection = new NpgsqlConnection(builder.ConnectionString);
NpgsqlConnectionDataProvider sqlDataProvider = new NpgsqlConnectionDataProvider(sqlConnection);

// Part 3: Creating the List & Label object, adding the SQL data provider
// and call the Designer
using(ListLabel LL = new ListLabel())
{
	LL.DataSource = sqlDataProvider;
	LL.Design();
  }

… which opens the Designer, automatically filled with the data from the database specified in the connection string. From here you can continue with our Designer-Tutorials.

Hint: You can also easily access CockroachDB data with the PostgreSQL data provider.

Building Reports from PostgreSQL Data

List & Label provides an integrated Report Designer. You or your end users can use it to design the reports and determine the output. Use the wide range of visualization options to make your reports clear and comprehensible.

Charts & Graphics

Create reports with intuitively understandable graphics. For example, with different chart types, gauges, shapefiles (e.g. for geovisualization) and much more. Also use the Rscript support for individual chart types.

Designer Objects

Add barcodes, graphics, RTF text, PDF objects, tables, crosstabs, charts, custom objects, extensive master–detail reports/sub–reports and many more designer objects.

Languages

The Enterprise Edition of List & label provides the Report Designer menu in more than ten languages. The localization of project files and Unicode support make your application ready for international teams and projects. Have a look at the language kits.

Additional Data Binding

Do you want to bind additional data sources to the PostgreSQL data and make them accessible together? List & Label contains more than 30 data providers for other data sources such as XML, SQL, NoSQL, LINQ, CSV or Business Objects/ORM.

Interactive PostgreSQL Reports in the Preview

To make reports more intuitive and informative for users, you can give them additional functions in the preview.

Drilldowns to enter any level of data.
Expandable regions to initially hide details that can be opened and displayed as needed.
Report parameters to limit or select what data is visible.
Forms with special input objects that users can add to their reports – input objects can also be used later in PDF format.
Vivid animations of individual objects added to the report.

Export and Distribution of PostgreSQL Reports

List & Label exports the report in the required format. There are many options that can be set for different formats, such as password protection or document properties.

Documents

Word/DOCX
Excel/XLSX
PowerPoint/PPTX
Rich Text Format (RTF)
XPS
PDF (including ZUGFeRD/XRechnung)

File/Web

XML
Text (CSV/Layout)
JSON
XHTML/CSS

Picture

JPEG
SVG
PNG
Bitmap
Metafile (EMF)
TIFF/Multi-TIFF

General

Printer
Preview
Presentation
Pinwriter (TTY)
Printer binary file (PRN)

Email distribution:

Easily distribute your reports via email using SMTP, Microsoft Graph API, Simple MAPI or XMAPI. Optionally, the export results can be packed directly into a ZIP archive by List & Label.