The Dotnet Report v6.0.3 release introduces powerful new visualization capabilities and advanced data handling with JSON joins. These updates are designed to improve flexibility, enhance chart customization, and expand support for modern data structures. Below are the key enhancements in this version:
What’s New in v6.0.3?
Combo Reports – Mix and Match Visualizations
A new report type, Combo Reports, is now available. Users can select a default chart type (Bar, Area, or Line) and assign different visualizations to individual fields. The final report displays a combination of chart styles in a single view, perfect for comparing metrics in diverse formats.
Line Chart Enhancements – Now Supports Area View
Line charts now support Area-style visualization, offering a new way to highlight trends and data ranges while maintaining the clarity of line-based reporting.
Donut View for Pie Charts – Enhanced Visual Option
Pie charts now include the ability to switch to Donut view. This adds a cleaner, modern look while retaining all underlying data insights. Users can toggle between Pie and Donut formats with ease.
Dashboard Chart Switching – On-the-Fly Visualization Changes
When building dashboards, you can now dynamically change chart types using built-in options. For example:
- Swap between Pie and Donut
- Toggle Bar charts to Stacked or Horizontal
This flexibility allows you to quickly adapt the dashboard visuals to better suit your reporting needs.
JSON Field Joins – Advanced Data Linking
Joining on JSON fields is now fully supported:
- JSON fields are displayed and selectable in join configuration.
- During report creation, nested JSON keys can be extracted and used like regular fields.
- You can join JSON values (e.g., customerID inside a JSON column) to another table (e.g., orders.customerId).
- Join logic is generated automatically and can be previewed in Admin Mode
Admin Mode SQL Preview – Greater Transparency
When Admin Mode is enabled, you can now preview the SQL query generated by your report before running it. This gives developers and power users more insight and control for debugging or verification
Improved Join Configuration – Easier Management
A small but important UX improvement: when adding a new join, it now appears at the top of the join list, making it easier to identify and configure. Previously, new joins were added at the bottom, which was cumbersome when managing many joins.
Try It Live – Visual Demos Available
Want to see the new charts in action? Try them out here in our Live Demo
Summary of Changes:
- Added Combo Report type for mixed chart visualizations
- Line charts now support Area view
- Pie charts now offer a Donut view toggle
- Dashboards allow dynamic switching between visualization types
- Enabled joins on JSON fields, with full frontend and SQL support
- Added visibility of SQL query in admin mode
- Improved UX for adding and managing joins in report builder
These updates further strengthen Dotnet Report’s flexibility and power, especially for users working with complex or semi-structured data. For questions or feedback, feel free to reach out!
