Using Reporting Services 2012 With SQL Server 2010

Here in this article you will learn how to work with Reporting Services 2012 with SQL Server 2010 and Visual Studio 2010.

Many issues concerning use of reporting services in Visual Studio 2010 occur due to omission of the template in Visual Studio 2010. Microsoft's SQL Server Data Tools helps developers design server reports and deploy to the server then the Visual Studio report viewer can access them using the server report option. The following procedure provides guidance for the use of these tools.
 
Step 1: Download and install SQL Server Data Tools 2012: Download the application from http://go.microsoft.com/fwlink/?LinkId=273673 and run "SSDTBI_VS2012_x86_ENU.exe". The installation is as simple as SQL Server installation. During installation you might be asked to download another service pack of Visual Studio; if so then do download and install it before you continue. For more info check http://technet.microsoft.com/en-us/library/jj856966.aspx for installation help.
 
Step 2: Create a new Project: Open SQL Server Data Tools 2012, click "File" > "New" > "Project...". Select "Report Server Project Wizard" in "Reporting Services" under "Business Intelligence". Provide the names for your documents and click OK. You can choose Report Server Project to skip the wizard if you are familair with the creation of reports.

image1.png
 
A welcome page will appear, click "Next" to continue
 
Step 3: To choose a Data Source and Data Set for your report, choose "New DataSource" and give it a name. Select the database type and click "Edit" to select the database.

image2.png
 
Step 4: Select your database and select the authentication type. Click "Ok" to continue. Click "Next" to go to the next dialog.
 
Step 5: Type a query string in the query string text box or click "Query Builder" to use the wizard.

image3.png
 
Step 6: In the query builder, click "Add Table" and add the tables and other objects you need.

image4.png
 
Step 7: Select the columns and click "Ok". The query automatically generates an SQL code on the query string text box. Click "Next".

image5.png
 
Step 8: Select whether table or matrix and click "Next".
 
Step 9: Specify the Details, Groups and Page contents of the report. Choose your column and row headers if using a Matrix.

image6.png
 
Step 10: Select your table data arrangement, either stepped or blocked and click "Next".
 
Step 11: Select your preferred table format and click "Next".
 
Step 12: Skip the Next Dialog by clicking "Next", name the report and click finish. We will attend to the skipped dialog later in this article.
 
Step 13: Click "Preview" to view the generated report.

image7.png
 
Step 14: Remember the part we skipped in Step 12? We may now give it attention. The reports are server reports so they can be accessed by various clients in the same Network. Therefore, the Report should be deployed to a specific server where the clients can have access to them if granted. To do this, at the time you installed your server (SQL), the Reporting Service Configuration app was installed too. Open it and connect to your server.

image8.png
 
Select Report Manager URL on the left of the app so you can see the name of your deployment server.

image9.png
 
Copy the Link.
 
Go back to SQL Server Data Tools, select "Project"  - "Report Properties".

image10.png
 
Remove the link in Target Server URL and paste the copied link and click "OK".
 
Step 15: Click "Build" in the menu toolbar and click "Deploy Project". A permission error will be displayed if you are not an administrative user, either you login in as admin or you open the SQL Server data tools as Admin. In the output, you will find the deploy activities and process, you will also see the target URL and the report path.

image11.png
 
Step 16: Copy the URL and the Report Path.
 
Step 17: Open a new Windows Form Project in Visual Studio.
 
Step 18: Drag and drop a Report Viewer control and the Form, then click on the small arrow on the top-right of the report viewer and click "Dock in Parent container".

image12.png
 
Step 19: Click on the same arrow and click the "Choose Report" combo box. Select "Server Report" and paste the items you copied in Step 16. FYI: The report path must start with a forward slash as in the following

image13.png
 
Run the Visual Studio application and ensure it is also open as an admin, if not you will not be granted access to the server.

image14.png
 
One More Step.. Step 20: Say Hi, if you find this article helpful or recommendable. Thanks
 
Happy Developing.