You can use the DSS Flow to apply the report's business logic and generate the required Dataset from your source Database. For Every Report, you can have the pipeline reading source data applying business logic and the output will be the final Report Data.
Now, if the requirement is just to output the final data in a Tabular Form with some filters. Use DSS Dashboard capability and add a Dataset Tile and a filter Tile. The DSS Dashboard is synced with the underlying table and will get automatically refreshed. For Charts, use DSS Charts to be published in Dashboard.
If you want to bring your own Visualization Tool, you can integrate it with DSS or underlying DB and use that.
DSS - Tableau Integration
DSS - Power BI Integration