How to export report to JSON
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, 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 powerful toolkit of FastReport.Net, you can easily create data sets with complex structure 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.