SQL - Reporting Server - Part II

Create a New Report Server Project


1. Open Visual Studio.
2. New --> Project -->
   2.1. Select Project type --> Business Intelligence Project.
   2.2. From the template select  Report Server Project.

3. In the solution, Right click in Shared Datasource and select Add New Datasource.

4. In the properties window general tab enter the data source name and server type.

   4.1. Create new connection click Edit button.

   4.2. Or you can directly enter the connection string a in the text box. And In the Credentials tab enter the username and password.
 Eg.  Data Source=SAM;Initial Catalog=NHG;

Adding New Reports:
   You can add the report in two ways.
  1. Using Report Wizard.
  2. Using Bland Report.


  1. Using Report Wizard.
1.1. In the solution, Right Click at Reports and select Add New Report. It will display the Report Wizard to generate Report.

2. Using Bland Report.

 2.1. In the solution, Right Click at Reports and select Add New Item. In the template select Report.

 2.2. Go to Report data Tools menu and Click New.

 2.3 In the Dataset Properties Window select the New Datasource.

2.4 Select the Query Type and type the query are paste then click Ok button.

2.5. The result dataset available in the Report data tool bar.

2.6 Design the Report Using Table. Insert table using Table control in tool box.