Pro SQL Server 2012 Reporting Services

(sharon) #1
CHAPTER 3  INTRODUCTION TO REPORTING SERVICES DESIGN WITH SQL SERVER DATA TOOLS

Figure 3-3. Project properties


 Note We’ll cover some of these other settings, such as TargetDatasetFolder, TargetDataSourceFolder, and


TargetReportPartFolder, in Chapter 8. However, unless the object needs to be consumed by report developers


or end users with no access to the specified TargetReportFolder, its good practice to store your project objects


using the folder structure that you set in the TargetReportFolder. For example, the TargetReportFolder in


Figure 3-3 is Pro_SSRS and the TargetDataSourceFolder is set to Pro_SSRS/DataSources. This prevents other


developers overwriting your data sources, datasets or report parts.


Setting Up a Basic IDE

Now that you have a new solution and a new project to contain the reports you’ll build, it’s time to get
personal. As a report designer, you’re going to spend many hours gazing at the pixels that are your
creations, so it’s important to set up the environment exactly the way you want it. The ideal setup for
designing reports is a personal choice. Some prefer high-resolution display settings with every available
design toolbar always in view within the environment, while others like undocked toolbars and a dual
monitor set up at a lower resolution. Whatever your preference, BIDS makes it easy to manipulate the
design tools within the IDE to personalize your configuration. In addition to the Solution Explorer,

Free download pdf