Database Reference
In-Depth Information
Web portal: SSRS includes a Web portal, which allows you to view reports and manage sub-
scriptions. This portal is the primary user interface for the tool, and it allows you to perform
certain administrative functions such as organizing reports into folders, assigning permis-
sions for viewing certain reports, and configuring subscriptions and settings.
Developing a Reporting Services Report
In this section, you explore the mechanics of developing a Reporting Services report from scratch.
Follow these steps to start an SSRS project file, define a data source connection, and build a basic
layout for your report:
1. Open SQL Server Business Intelligence Development Studio and choose File ➜ New ➜ Project.
2. In the New Project dialog box (see Figure 12-1), select Report Server Project from the list of
Visual Studio installed templates, enter a name for your project, and then click OK.
Visual Studio creates a new SSRS project and opens the Solution Explorer, as shown in
Figure 12-2. Here, you see three folders: Shared Data Sources, Shared Data Sets, and Reports.
Figure 12-1: Open SQL Server Business Intelligence Development Studio and start a new Report Server Project.
 
Search WWH ::




Custom Search