Simple use of SSRS (i)

Introduction

SQL Server Reporting Services (SSRS), Microsoft Enterprise Reporting platform, and SQL Server integration service as well as SQL Server Analysis Services, are part of the Microsoft BI Suite. While SSRS and other Microsoft BI products are well integrated, SSRS and other platform product integrations are also easy. The SQL Server reporting feature provides your company with the ability to create, distribute, and manage reports. One of the SSRS report 1-1 shows:

Considerations for installation configuration :

Reporting services, as a component of SQL Server, is naturally installed with SQL Server. Many versions of SQL Server are currently available, and only enterprise and development versions have full support for SSRS. Therefore, when the enterprise deployment should choose Enterprise Edition, as a developer should select the development version. It is possible to select the relevant components of Reporting Services during the installation of SQL Server, or to change the installation of a SQL Server to add SSRS. It is important to note that the workstation components are installed on the machine that is being developed (which can be on the server or another workstation). One of the business Intelligence Development Studio must be installed.

Server-side configuration SSRs has two methods: Log on to server through SQL Server Management Studio, and the report manage page of the Web Access server, such as Http://IP/Reports. The two methods are slightly different in function, and the procedure can be used to view related documents.

Create and use:

as the focus of this article, we will go through each step in detail to illustrate its functionality and implementation through simple use.

1. Open SQL Server Business Intelligence Development Studio via SQLSERVER2008R2 and create

Create a new project from the file-new-project, create a report server project, and create a report (. rdl) file.

You have the option to select Category 3 report items:

• Report Server Project Wizard . Create a report project and solution and then immediately open the Report Wizard to lead you through the creation of a basic report.
• Report Model Project . Create a report model for business users that is available for use.
• Report Server Project . Create an empty report project and solution. This is also the option we do to get an accurate report layout.

After creating the report Server project, we need to create a new report to design. In Solution Manager, right click on the report directory, select Add > New Project

A name for the report, such as my name Myreport, when you click the Add button, an. rdl file is generated

2. In report data, create and configure a DataSource, where the SQL Server local business database is connected.

Common data sources that are supported, including:

-Microsoft SQL Server, SQL Server Analysis Services

-Oracle, SAP NetWeaver BI, Hyperion Essbase, Teradata

-Report Server Model,xml,ole DB, ODBC

Create a shared data source

Open Business Intelligence Development Studio (BIDS). After you have created the report Services project, you can see the shared data source directory in the solution Manager (sharer data Sources). Right click on the directory to select Add New data source

Shared data source, the Data Source wizard appears next. We can see the data source name, type and connection string in this window, which can be automatically generated by the Edit button;

3. Creating and Configuring Datasets DataSet

Classify a shared data source as a report data source;

Create a DataSet1 that defines the report query statement to retrieve the information (ignoring the Where condition first). Right-Join the dataset, select the embedded dataset to be stored in a single report, select the previously configured DataSource1, and then write or configure T-SQL query statements by hand or through the configurator.

When finished, the insert result set is displayed, and so on. Click the + sign to expand the tree menu to see the available fields.

On the parameters, I simply show that there is no understanding of the future will be explained in detail

Right-click Parameters folder, creating parameters

Right-click Data set for property configuration

Summarize:

So far, we have connected to the data source and know the report elements that we need to use. We can also use the shared information created by this report in other reports. For a desired report, you also need to know what data to show, group rows and columns, sort by some naming conventions, and show data in a specific format. Next we will show you how to display

Simple use of SSRS (i)