Pro SQL Server 2012 Reporting Services

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0

Figure 13-30. Previewing a new Branch Name group

Deploying the report to the report server is as simple as clicking the Save button on the toolbar.

After clicking Save, a Save Report dialog box appears that allows you to navigate to an accessible folder

on the report server; in this case, open Pro_SSRS folder by double clicking it. If you do not have a

Pro_SSRS folder on your SSRS 2008 R2 server, simply navigate to the Report Manager

(http://localhost/Reports/) and click the New Folder button on the toolbar of the home screen. Name

the folder Pro_SSRS and click OK to create the definition of the new folder in the ReportServer database.

Name this report Patient Face Sheet, as shown in Figure 13-31, and click the Save button.

You can navigate to the Report Manager later to make sure the report was saved successfully, but for

now, you will move on to the next type of report you will learn how to create, a matrix report.

 Note Though you will save the report to the report server and can load it back into Report Builder 1.0 for

modification, it is possible to open a Report Builder 1.0 RDL file from a file location as well. Opening a report from a

file is a choice in the task pane, accessible by selecting the Task Pane under the View menu or by pressing

Ctrl+F1.