Before Designing a Report
Before designing reports, consider the following points:
Has the data source application been designed to support the required hierarchies and calculations for all reports?
What is the goal of the report?
Who are the end users of the report?
How frequently is the report generated and by how many users?
What is an acceptable retrieval/generation time?
How many cells does the report query before suppression?