SSRS:Report

Refer Source Video:SSRS How to create a report video tutorial SSRS 2012
---------
Solution Explorer:
Project
Shared Data Sources:
        (In the "Edit" button specify the connection, Server,Database)
Shared Data Set:
Reports:

In the Report: 
1.Data Source:choose the defined "Shared Data Source" which has connection to server & Database        mentioned.
2.DataSets: Choose "Query" there define the query
3.Report:Create Report by pulling "Data Sets" fields
For Report View menu->Choose Toolbox-Table
--------
Report Data
------------------                                                          
Build-in fields
Parameters
Images
Data Sources
DataSets
  -field1
  -field2

Solution Explorer:
-Shared Data Sources
-Shared Data Sets
-Reports
   -abc.rdl
1. Go to Visual Studio 2010
2.File - New -Project - Report Server Project
3.
Solution Explorer
SSRSProject
Shared Data Sources
Shared Datasets
Reports
4.
Solution Explorer
SSRSProject
SharedData Source ( Add New Data Source:Name Type:Microsoft SQL Server
Edit (Connection: Server Name:. Use Windows Connection Database:
5.
Reports:Add:New Item:Report:Name:abc.rdl:Add
6.Data Source:use the shared Data Source

6.DataSets:Add DataSets:Name:Use a dataset embedded in my report:Data source:
Query Designer:Add table:Employee:Fields:
Select statement created : shows as report fields

5.View:Toolbox:Drag Table;choose fields

6.Formatting:

Preview