Generic Reports

Background

As working on fintech report was one of the major and most used features by Business users
We used to create multiple reports weekly
Creating reports was easy to work on, but creating separate pages for each report was a time consuming task
We wanted to develop something generic that can solve this problem
Also, we had a few Crystal Reports and a few in sliverlight UI.

We thought to create a backend driven reports
Everything will be configuration based
Was aiming at report creation should not take more than half day
It should simple as creating store proc, saving the configuration in the database, that's it.
There should be an ability to use this report anywhere in the application
There shall be exports features
Shall be able to display multiple datasets
Report link should be bookmarkable

Backend

Configuration of Report in tables

SP or Views

API Controller

- GetReport

- GetData

- GetReferences

Title of Report

Label

Submit

Export

https://xyz.com/report/1/sample-report

ReportId	Title	Parameters	Tabs	DataSource	Config
1	Test	{ columns: [{type: 'int', displayName: 'Id'}, {type: 'string', displayName: 'name'}, ..], filters: [{paramName: 'test', displayName: '', defaultValue: 'Test'}]

Report

Store Proc

Views

API Controller

- GetReport

- GetParameters

- GetData

By Pankaj Parkar

Indian | 30 | Ex MVP | Angular GDE