Report Data How-to Topics (Report Designer)
The first step in creating a report is to define a data source connection and specify a query that retrieves the data you want to use. In Reporting Services, the data source connection and query is part of a dataset. A report must contain at least one dataset, but you can create multiple datasets if you want to use data from a variety of data sources or queries. This section provides step-by-step instructions for adding data to a report.