Thank you L' Eomot Inversé , but as per our requirement a separate history table for each attribute table could result in a massive amount of table. Additionally with such deisng I wouldn't achive auti requirement of showing change log in verticle manner(table, col, old value, new value)

I came up with few other apporach may you can validate and tell me which one can be consider...

1. Apporach 1 - Created Single Report Data table - With this apporach whenever the report is generated I will generate the report data and store it in the table henceforth, whenever user access that report data will be displayed from this single table. The advantage is its one time processing, my requrirement is getting fullfill i.e. each time user display the report system should generate back dated data that was genrated earlier.

2. Instead of having Single Report Data tabl, creating One report - One table. By this way, I am offloading load from single table into multiple tables.

3. Is there any way if i create History tables (replica of main table) I can generate audit report in verticle manner for all columns from entity? - (Table Name, Field Name, Old Value, New Value, Change Start Date, Chnage End Date)

please provide your views....