Getting Started with SQL Server 2008 Reporting Services

Directory

Installation and configuration of Reporting Services

The process of developing a report

Report Making Example

First, the installation and configuration of Reporting Services

1. Components of Reporting Services

2. Installation of Reporting Services 2008

2.1 There are two ways to install Reporting Services on SQL Server 2008:

• Default configuration
• File Installation

2.2 Assumptions for the default configuration:

• Installing a relational database in the same instance
• Service account for database connection

2.3 The configuration will no longer be included in the installation:

• Remote directory database (included in SQL 2000)
• Scale-out deployment (also known as Web Farm) installation

2.4 SMTP Server Configuration

• Default Web site (a new application pool will be created in Windows 2003)

2.5 client Installation includes visual Studio 2008 Kernel (Business Intelligence development Studio)

3. Reporting Services Configuration steps

3.1 Configuration Interface:

Open Microsoft SQL Server R2---Configuration tools-->reporting Services Configuration Manager.

• Service account: Generally choose to use the built-in account, depending on the user's needs;
• Web Service URL: Provides a URL for accessing the report server, such as Http://localhost/ReportServer;
• Report Manager URL: Provides a URL for accessing Report Manager, such as Http://localhost/Reports;
• Database: If you have already created the report server database, select "Existing Report Server database", otherwise "create a new Report server database", the Report server database Select "ReportServer", enter the local user name (domain \ User) and password in the credentials, complete the configuration;
• In addition to the above configuration, several other configurations generally adopt the system default configuration.

Second, the process of developing the report

1. Report making process

Iii. Examples of report making

Create reports can be created through business Intelligence Development Studio in Microsoft SQL Server R2, or in Microsoft Visual In studio, you create a report by using the ReportView control. This example creates a report using business Intelligence Development Studio in Microsoft SQL Server R2.

1. Create a Report Server project

Before you make a report, you create a report server project in which you can hold several reports for users to call. The steps to create a report server project in Business Intelligence Development Studio are as follows.

1.1 Select "Start" | "All Programs" | "Microsoft SQL Server R2" | "Business Intelligence Development Studio" to launch the Commercial Intelligence development environment. In the menu bar, choose File | new | Project command to bring up the new Project dialog box. Select the Business Intelligence Project option in the Project type list, select the Report Server Project Wizard option in the Template list, enter report Project 4 in the Name text box, and click the OK button to create the project.

1.2 The system will pop up the Report Wizard dialog box.

1.3 Click the Next button to enter the operation to create the data source.

2. Create a data source

The data source is essentially the definition of the connection from which to get the data location, either a connection to a SQL Server data source or a connection to any OLE DB or ODBC data source.

Data sources are the most important content in Reporting Services. Regardless of the type of report you are building, and whether the report is using a report model or a report project, it works in some way. There are two types of data sources: embedded and shared.

2.1 Enter "Bookshop" in "New data Source Name", enter "Data source=localhost;initial catalog=bookshop" in "Connection string", click "Next" to enter "Design Query" interface;

2.2 In the design query interface, you can choose to design a query using Query Builder or you can enter a query statement directly in the query string text box "Select ID, type, Name, Author, Translator, Publisher, OriginalPrice, Price, Cover, Hits, Sales, Status, recommend from book ";

2.3 Click Next to select the type of report: Table or matrix;

2.4 Finally enter the report name "Report1" in the Completion Wizard and the report project is created.

3. Design the report

In Business Intelligence Development Studio, choose View | Toolbox command from the menu bar, and use the report items in the toolbox to design the report to refine the report.

4. Publish the report

After the report design is complete, the next step is to deploy the report, with the following steps:

4.1 from the menu bar of business Intelligence Development Studio, select Project | Report Project 4 Properties command to bring up the report Project 4 Property Pages dialog box. In the TargetReportFolder field, set the folder where you want to host the report when you log on to Report Manager. In the TargetServerURL field, enter the Web service URL for the report server. In this case, the URL is simple and http://localhost/ReportServer. After determining these parameters, click the "OK" button to return to business Intelligence development Studio for deployment.

4.2 Deployment will be completed shortly by selecting the Build | Deploy Project report 4 command in the menu bar of business Intelligence Development Studio.

4.3 When the deployment is complete, you can view the report. Start the browser and open the address http://localhost/ReportServer. Click Report Project 4---Report1 to view the reports that have been built. You can export a report by right-clicking to select an export format.

4.4 Start the browser, open the address http://localhost/Reports, you can see the SQL Server Reporting Services home folder, you can make some settings in the folder.

Here, a simple report has been completed, I hope you can make more valuable comments.

Ext.: http://www.cnblogs.com/YZDONET/archive/2012/08/17/2644711.html

Getting Started with SQL Server 2008 Reporting Services