Introduction

One of the main lookout features from the transformation to SSRS reports is the ability to support multiple sources to render data. An ERP is one of many single corporate systems, with the data involved in making decisions spread across multiple systems. It is important that the reports are able to pull through data from different sources. For example, when a company switches to a new ERP, the legacy system is still kept alive for transactional data references. This chapter will focus on offering recipes that involve different sources of data, such as XML feeds, SQL databases, and OLAP that can be used as a datasource for the report.