What’s New In v5.1.0?
We are excited to announce the newest update to dotnet report. This update includes new features to help you get the most out of your reports and data analytics.
The Key New Features include
- Handle JSON fields in dotnet report
- Create Custom Data Views/Set
Handle JSON fields in dotnetreport
New Feature: JSON BLOB Column Support
– 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.
Create Custom Data Views/Set
We have introduced a new feature in DotnetReport that allows you to directly create and integrate custom data views, saving you time and effort. With this update, you can seamlessly connect your custom datasets, including custom joins and queries, without the need to create SQL views at the backend.
Here’s how the process flow works:
- Open DotnetReport and associate a new database.
- Integrate a new table and navigate to the Custom Data Views tab.
- Clicking on the Custom Data View tab will open a pop-up window where you can directly paste your custom queries.
- Give your custom query a name for easy reference.
- Save your changes. If the SQL query is error-free, it will be processed, and a new table corresponding to your query will be created.
- You have the flexibility to rename the created table for better organization.
- You can also edit and re-process the added SQL query if needed.
- The custom table generated from your query can be seamlessly used for reporting purposes, just like any other table in DotnetReport.
We understand the challenges users faced in integrating custom datasets and the backend efforts required to create SQL views. With the introduction of custom data views, we have simplified the process and empowered you to directly leverage your custom data in DotnetReport. Please note that the added SQL queries are validated to ensure they are error-free. However, you have the flexibility to make changes or cancel the operation using the cancel or cross icon in the pop-up window.