Pro SQL Server 2012 Reporting Services

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

Figure 13-24. Table report with patient information

Once you have added all these fields to the report, you could click Run Report to preview the report;

however, at this point, you must perform some tasks to make the report fit on a printed page. In its

default page setup, the report is set to Portrait; however, the fields you have added extend beyond 8.5

inches across. To fix this, right-click in the design area, and select Page Setup so that the Page Setup

dialog box appears, as shown in Figure 13-25. Set the Orientation property to Landscape, then set all of

the Margins to 0 and click OK.