Pro SQL Server 2012 Reporting Services

CHAPTER 7  USING CUSTOM .NET CODE WITH REPORTS

Figure 7-1. Creating a Visual Studio BI proJect

To add the existing EmployeeServiceCost-NoCode.rdl file to your new project, right-click the Reports

folder, and select Add  Existing Item, as shown in Figure 7-2. Alternatively, with the Reports project

highlighted, select Add  Existing Item from the menu. Next, browse to the location where you installed

the Chapter 7 samples, and select EmployeeServiceCost-NoCode.rdl from the Reports folder. You will

also need to add the shared data source by adding an existing item and picking the Pro_SSRS.rds file

from the same folder where the report was located.

Figure 7-2. Adding EmploYeeServiceCost-NoCode.rdl to Your proJect

To add the code from Listing 7-1 to the Employee Service Cost report, first open the report by

double-clicking it or by right-clicking it and selecting Open in the Solution Explorer. Next, with the

report on the Design tab, select Report Properties from the Visual Studio Report menu; alternatively,