Building Your First SSRS Report

In this section, you will learn the steps involved in building a report by building one from scratch with the sample AdventureWorks cube as a data source. To build a report against an SSAS cube for SSRS, you open BIDS and choose File New Project. In the New Project dialog box, you'll select the Business Intelligence Projects project type. You have three template types to choose from when building reports: Report Server Project Wizard, Report Server Project, or Report Model Project. For this discussion, we'll use the Report Server Project Wizard template, as shown in Figure 10–6.

Figure 10–6. To create a report, you open BIDS and select one of the three types of report templates.

After you select this template type, enter a project name, location, and solution name. Click OK. The wizard presents you with a series of dialog boxes.