Custom Data View in DotnetReport allows you to directly create and integrate custom data views, saving you time and effort. 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.
