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.

Idea

  • 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

Architecture

Backend

Configuration of Report in tables

SP or Views

API Controller

- GetReport

- GetData

- GetReferences

Title of Report

Label

Label

Submit

Export

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

Backend

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

API Controller

- GetReport

- GetParameters

- GetData

Generic Reports

By Pankaj Parkar

Generic Reports

  • 127