Microsoft® SQL Server® 2012 Bible

1239

Chapter 55: Authoring Reports in Reporting Services

55

FIGURE 55-2

The Reseller Contact Report, Preview mode.

You now have a report as a solid starting point. You learn the Report Designer environment

and build on this report throughout the next few sections.

Authoring a Report from Scratch

You have just created a project in the Report Designer using the Report Wizard. You

may also forego the wizard and create the same Reporting Services project by follow-

ing similar steps. From the Report Designer, go to File ➪ New ➪ Project. From the New

Project dialog box ensure that Business Intelligence is the selected project type, and then

select Report Server Project from the choices of available templates. Name the project

AdventureworksReports and select the fi le location for the project. Click OK.

To create the Reseller Contact inside a blank Report Server project, perform the following:

1. From the right side of the screen under Solution Explorer, select Reports.


2. Right click Reports, and select Add New Report.


3. If the Welcome screen appears with the Report Wizard dialog box, click Next.


4. Select the radio button for New Data Source.


5. Name the source AWDW.


6. Select Microsoft SQL Server under Type.

c55.indd 1239c55.indd 1239 7/31/2012 10:28:04 AM7/31/2012 10:28:04 AM

http://www.it-ebooks.info