logo
small logo
  • Products
  • Buy
  • Support
  • About
  • Customer panel Support
    • en
    • de
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to export report to JSON
  • The Event of ExportParameters in WebReport.Report

    October 5, 2020

    In FastReport 2020.1 we have added the ability to change export parameters. To do this,

    read more
  • MS Word format vs. Open Document Text. Which is better?

    October 19, 2020

    Speaking of text editors, we immediately present coryphaeus as Microsoft Word, which for many years

    read more
  • Want to generate tables for a user - Excel or OpenOffice Calc?

    October 8, 2020

    Tables. For centuries, they have been used to present similar data for record-keeping, counting amounts,

    read more
  • How to watermark a DOCX or RTF document in a .NET application

    December 6, 2021

    Watermark exports to .DOCX and .RTF files have been added in FastReport .NET. limitation -

    read more
  • How to upload a report to OnlineDesigner and download it after editing in an ASP .NET Core application

    June 30, 2019

    While working with Fast Reports online report designer, we usually have to upload our report

    read more

How to export report to JSON

October 4, 2016

 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.

about product buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET Export FastReport

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • FAQ
  • Tutorial Video
  • Forum
  • Support SLA
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Extended licensing
  • Contact us

© 1998-2023 by Fast Reports Inc.

  • Privacy Policy

Trustpilot