asked on December 21, 2022
Hi,
I am looking for a reporting and data visualization component for my application. The frontend of my application is developed in Vue 3 and the backend is developed in .net 6. This is a Saas application that is deployed in Azure and for each tenant, separate databases are created.
Please let me know whether we can use any flexmonster component within our Vue app to enable our end users to design and view reports on the fly. The user should be able to select the desired tables and fields and should be able to establish the relationship between two tables via UI.
⋅ December 23, 2022
Hello, Kumar!
Thank you for reaching out to us.
Flexmonster is a pivot table component.
It can offer dynamic report configuration via the UI, which includes:
Please note that all mentioned functions can be pre-configured from the code as well.
You are welcome to check out our demo: https://www.flexmonster.com/demos/js/pivot-table/.
We also offer UI guides for the end-users: https://www.flexmonster.com/user-interface/.
Flexmonster can be easily embedded into the existing Vue3 project.
Please check out our integration guide: https://www.flexmonster.com/doc/integration-with-vue-3/.
Regarding your questions about selecting the desired tables and adding the relationships between tables, we don't have such UI functions out of the box.
However, the desired behavior can be achieved by adding some custom logic. If it's possible to predefine the necessary datasets in advance, we suggest using our server-side tool called Flexmonster Data Server. If the dataset needs to be pulled out of the database based on the user input, we would suggest implementing our custom communication protocol to retrieve the data. You can always provide us with more details, and we will provide more specific recommendations.
Hope you will find our answer helpful.
Please let us know if you have any further questions.
Best regards,
Solomiia
⋅ December 29, 2022
Hello, Kumar!
Hope you are doing well.
Our team is wondering if you had some time to look through our previous answer.
Could you please let us know if you have any further questions?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ January 3, 2023
Hi,
Thanks for replying. I was able to generate a report using custom api.
Is there any way we can expose some or all tables of my Database using custom API or any other way? I do not want to join writing queries, but I would like to let the end user select tables and fields at runtime based on their requirement.
⋅ January 4, 2023
Hello, Kumar!
Thank you for getting back to us.
We are glad to hear that you successfully generated the report.
Our team is wondering how many data tables you have and if they are predefined or dynamically changing.
This information would help us greatly in coming up with the most suitable solution for your case.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ January 4, 2023
Hi,
Thanks for replying.
There are around 50 tables in the Microsoft SQL Server Database. The tables are already there in our database.
I want to enable the user to dynamically select the tables they need for their current requirement and generate reports/analytics/charts. I am looking for a user-friendly way for the end users so that they can dynamically choose the tables and create a join specifying the joining fields between the tables as some of our tables do not have foreign key relationships specified in the DB level.
Lets say I have 10 tables named Table_1, Table_2,.., Table_10 in our DB. Now I would like to expose Table_4, Table_5, Table_6, Table_7, Table_8, Table_9 and Table_10 to the end users.
At run time, from our application, the end user should be able to choose a subset of tables from the set of Table_4, Table_5, Table_6, Table_7, Table_8, Table_9, and Table_10 and establish a join if required by choosing the joining fields between tables. This needs to be done using a UI instead of having to use any query. And then the end user would be able to generate report based on those selected tables
⋅ January 5, 2023
Hello, Kumar!
Thank you for the additional details about your use case.
Our colleague has already described in detail the approach to use in a similar case.
Please, look through the following thread: https://www.flexmonster.com/question/how-to-expose-tables-of-microsoft-sql-database-tables-to-end-users/.
Hope it helps.
Feel free to ask if you have any further questions.
Kind regards,
Solomiia
⋅ January 26, 2023
Hello, Kumar!
Hope you are doing well.
Could you please let us know if the provided thread was helpful?
Looking forward to your response.
Regards,
Solomiia
