Separate "Reporting" Table or File?

[geraldh]

Hello All,

 

My boss would like me to look at some various reporting practices for FM.

This is for an event management company.

 

She was wondering if there is any merit to setting up a separate dedicated "report" table (or even file) that would capture data for financial reports (and other qualitative data) by month or season, etc.

 

I told her that we can always reorganize and summarize information according to date ranges and event types, etc. However, she would like to see if setting up a dedicated table (or even a dedicated file?) that would capture data for reporting deserves a try.

 

Only key summarized figures are necessary for these reports; so I can imagine file size/disk space should not be an issue.

 

Is it worth the effort? Any drawbacks? Any opinion would be greatly appreciated.

 

Thank you

[mr_vodka]

I use a separate file for reports. I also store data for those reports as well. For example, for reports that store month end historical data, it make sense to save those summaries off into one record.

[geraldh]

Thank you John Ahn for your response. It does make sense, and it is reassuring to hear that others might be doing this.