Report System in Flask

Reports plays a major role in current business outlook for making critical and non critical decisions. Business people always like to play with reports in terms of analyzing the business flow and status. This inturn becoming a unavoidable component in the mind of 2K entrepreneurs & beyond.

When we are developing an application, the Reports module adds more value to the application, It doesn’t matter on scales of the(small/ large scale) application. Because Data always in demand and charm as well.

We spend a lot of time building the table report. The process includes:

1. Define filters for each report.
2. Write SQL query.
3. Write API for each report.
4. Set the color for data to make a better look.
5. Build UI for it.

Implementing these steps in a web application is time-consuming and needs Dolo 650 to overcome it. I implemented Report System which enables you to create reports by writting SQL queries and configure filters by clicking the dropdown in UI. No need to write any code for it. We can merge this code with any other application.

we can make the above steps more modular with a database level configuration.

DB Structure

flask_parameter and flask_report tables are master table, flask_report_parameter table is an association table.