How to export report to JSON

2016-10-04

 It's nice that the range of formats to export reports to FastReport.Net constantly grows. With the ability to use JSON files as the data sources there appeared export support for this format (2016.2). JSON files are used for data transfer between the client and server web applications.

Export saves the data structure of the report. This is especially useful when exporting tables or matrices. Because JSON is created for storing data, the export will contain only the data structure and the data itself.

Now let's look at exports to JSON format using a simple matrix:

 

Run the report in preview mode:

Now exporting to JSON format:

 

Export settings window appears:

 

Actually, all the settings are reduced to a choice of report pages. Click the OK button and select where to save the file. The file can have the extension txt or JSON.

Now let's see the export results in a text editor:

As you can see, the document structure is quite simple, and that is the main advantage of JSON.

The entire matrix was placed in the TableObject object. The content of the matrix is stored line by line. This provides good readability, unlike XML. In fact, we see the same matrix only in text form.

Thus, by exporting a report in the JSON, we create a data source that can be used in a web application or other FastReport reports.

And yet, you may ask, why use the FastReport, if the ultimate goal - a set of data to JSON format? Using the powerful toolkit of FastReport.Net, you can easily create data sets with complex structures and calculated fields. That is to use a report generator, as a means of constructing a data source. Then, we export the report to JSON and use it for their own purposes.

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.