Building a Multi-table Report with SQL 2005 Reporting Services - Create an RS Project

(Page 2 of 6 )

The New Project window shown below can be accessed from the File---> New Project... drop-down from the main menu. You will find the Business Intelligence Projects at the top of the project Types. When you choose this as the project type, you can choose from a variety of Visual Studio installed templates, of which there are two items related to SSRS.

When you choose the Report Server Project Wizard and choose a name for the project, RSMulti in this tutorial, you will put the wizard in motion. The wizard shows up with its customary window as shown in the next picture. If you read the welcome screen you will see that the Report Wizard provides all that is necessary to create the report from data access to report formatting.

When you click the Next button, the Report Wizard - Select the Data Source window shows up. This is an important step where you need to provide the inforamtion for the data that is going to be incorporated into the report. You have the possibility of choosing an existing data source or creating a new one. In this tutorial a new data source will be created.

Next: Connecting to data >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Building a Multi-table Report with SQL 2005 Reporting Services

· SQL 2005 Server's RS is a full service reporting tool fully integrated with VS...    · i would like to know how to generate multi-table ( belong to different databases)...   >>> Post your comment now!