SQL Server Reporting Services 2012 Projects with Visual Studio 2012 - Learning SQL Server Reporting Services 2012 - page 111

11. Click on Data and then on the icon, and choose to create a new data source.
The Dataset Properties window will be displayed.
12. In the Dataset Properties window, click on New... for the data source.
The Choose Your Data Connection page of the wizard opens.
13. Click on New Connection... .
14. In the New Connection window, establish a connection to SQL Server 2012
Kailua , and choose to use the Northwind database. This was already seen in
the Hands-on exercise 2.1 - creating a report using the Report Server Project Wizard
section. Choose your Data Connection gets updated with the following
Connection string :
Data Source=HODENTEKWIN7\KAILUA;Initial
Catalog=Northwind;Integrated Security=True
15. Click on Next . The Choose your Database Objects page will be
displayed, and after some processing, all the objects on the Northwind
database will be displayed.
16. Choose the Orders table from this list. Change the name of Dataset to NDS .
17. Click on Finish . The Dataset Properties page gets updated, displaying
all fields (with their type name) from the Orders table. Click on OK .
Now, if you click on Data and then the icon in the 3 x 2 table you will
see the column list from the Orders table.
18. Drag-and-drop items from the list on to the 3 x 2 table, as shown.
If needed, you can insert as many more columns as you need:
19. Now back to the Default.aspx page. Click on ReportViewer Tasks ,
and choose Orders.rdlc , as shown.