CHAPTER 3 INTRODUCTION TO REPORTING SERVICES DESIGN WITH SQL SERVER DATA TOOLS
Figure 3-2. New Project dialog box
If you know where your reports are going to be deployed, it is considered good practice to add a few
important project property settings: the target folder in which to deploy the reports on the SSRS server,
and the SSRS server URL. You can view and set these properties using the Solution Explorer, whose
window displays the opened solution and the projects it contains, as well as all the reports and other
objects the individual projects might contain. By default, BIDS locates the Solution Explorer on the right
side of the environment, but it may be docked or floating in a different location. If you do not see it, click
View ➤ Solution Explorer on the menu bar. Highlight the project in the Solution Explorer and choose
Project ➤ Properties from the menu (or right-click the project and select Properties) to see a window like
the one in Figure 3-3. The TargetReportFolder property controls the folder that is created to store the
deployed reports and data sources on the SSRS server. You can use the TargetDataSourceFolder and
TargetDatasetFolder properties to store the project specific data sources and shared datasets. The
TargetServerURL property is the SSRS Web server URL (when you start to use SharePoint Integration
Mode, as you will when you get to Chapter 12, this property will contain the SharePoint server URL). As
Figure 3-3 shows, the TargetServerURL property is in the form http://servername/ReportServer. In this
case, the SSRS Web server is localhost.