Abstract-Business intelligence (BI), which has proven to be a key strategy to improve business benefits and performance, is a crucial need for information and communications technology (ICT) industry. Data warehousing and reporting are two concepts that BI provides to create meaningful information from integrated data. Microsoft offers SQL server reporting services (SSRS) as a reporting solution to provide a ready to use, scalable, versatile platform to create, deploy and manage reports.There are numerous studies that define data warehouse and reporting, their components, usage and benefits in the literature. In addition to such studies, this paper presents implementation scenarios of taking reports from different data sources to show difference between taking report from operational database and data warehouse by using Adventureworks database.