Why computername because when we install SQL Server on our machine, SQL Server makes our system itself a server. But when you do not give any name, it takes a default name.ĭefault names like (local), localhost, computername. You give a name to the installed Instance. When you install SQL Server, Either you create default Instance of SQL Server or you create instance with selected features depending on the requirements.

One important thing I want to mention is the Server Name.

I will be using Adventure Works 2012 as a Source Database. We will talk here about the Embedded Connection onlyĬlick Edit Button to Select Server, Database for the Report Data. To Preview the report before finishing the wizard.Īnd now the Final View of Report in Data Tools (SQL Server 2012)Ībove Figure has Data Source name, type and Connection Options. The Next window is the completion of wizard. Please look and verify the query string, and go for the Next Screen by pressing Next.Ĭheck the option Enable Include Subtotals if you want to include subtotals into the report. The next screen will be, the window to write the query to fetch the data from the database. In the previous image, if you guys see the connection string which has AdventureWorks2012 so in this post I will be using this database. Why we choose this option because we make our Datasource shared for the whole project.īy choosing this option we are enabling the functionality to use single data source for whole project, and can create as many as reports using single shared data source.įor now we will go without selecting this option, by going on Next. Please Go to my previous post to choose particular Datasource for reports. Go to next screen by pressing Next button Welcome to the creation of SSRS Reports using Report Wizard given by Microsoft SQL Server BI Tools (Data Tools for 2012)

Sql server bi tools