Getting Started with SSRS (ii) creating simple reports

Report Services is a component of Microsoft SQL Server Business intelligence, with Reporting Services, users can produce a variety of reports, whether simple or complex reports, while the system provides subscription capabilities to facilitate users to subscribe to the report. In addition, developers can easily integrate a SSRS report into their own WinForm or WebForm programs.

This article will explain how to create a simple report that you will have an understanding of the steps to build a report project.

First, open SQL Data Tools, the shell of Visual Studio 2010. Projects related to business intelligence, such as integrated services projects, Analysis Services, etc., need to be used.

To create a new project, select the report service under Business Intelligence in the list on the left, and then click OK after selecting the Reports Server Project project in the project template, after taking a name for the project below and determining where to save the project file.

In the Solution Explorer of the report Services development interface, you can see that the structure of the project is still very simple, by default it is divided into three folders, shared data sources, and shared data collection report folders.

Right-click the shared Data Sources and select Add New data source to create a new one.