There is no golden rule that say that you must use a multi-tiers architecture in all cases. If performance is an issue, let the reports talk directly to the database. Just make sure to document well the application and tell why you used that approach.

>One more question, let's say that you run a report for all the items that were sold for a month and it's thousands of records. How do you handle this? What are the memory issues in this scenario?