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.

September 19, 2024

How to troubleshoot the most common issues when installing FastReport VCL

We have compiled a list of the most popular problems when installing FastReport VCL and have prepared detailed instructions on how to fix the problems that have arisen.
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.
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.