1. Home
  2. Getting Started
  3. Schema Setup
  4. Adding Json Field

Adding Json Field

– Users can now associate JSON BLOB columns from their database tables with DotnetReports.

– Introducing a new field type, “JSON,” in the field type dropdown, allowing users to specify JSON data columns.

– Users can define the required JSON structure for extraction using the JSON data structure field (e.g., {“FirstName”:”Max”, “LastName”:””, “CustomerId”:””}).

Streamlined Data Extraction and Reporting

– All defined JSON BLOB columns will be shown separately under the “Select Data Fields” section while creating a report.

– Users have the flexibility to select one or multiple JSON columns for reporting purposes.

– Upon saving and running the report, individual JSON blob columns will be displayed in separate columns, alongside a combined view of the entire JSON structure.

– Users can choose to hide or show individual or combined versions of the data using the existing hide/show icon available against each selected table column.

Was this article helpful to you? Yes No

How can we help?