In this article, you will learn about SSRS Report with VS 2015.
Requirements
Installation and Configuration
Need to configure SSRS After configuring the connection,
The screenshots given below help to describe creating reports on the Server. The Business Intelligence Development Studio is used to create the reports. Step 1 Step 2 Click next. Step 3 You see the next screen Give DataSource name and click edit. Step 4 Choose SQL Server and database. Give the credential details by clicking Edit button. Step 5 Click Next. Step 6 Click query builder. Step 7 Click the symbol (add table), select and add the tables required and click close. Select the fields required from the Table, it will form a query. Click OK. Step 8 Click Next. Step 9 Select report type, followed by clicking next. Click Next. Step 10 Design the table. Click Next. Step 11 Add the report name. Click Finish. Step 12 Step 13 Select the Preview Tab, give the DataSource credentials and the report will be previewed. Step 14 The next two steps are important.
Build the report. Deploy the Report Right click on project --> Properties-->Change the TagerServerURL to the WebService URL. Click OK. After deploying the report, you can see the output. These two things will be used in the Web Application for rendering the report. We can see the DataSource created by the given name dsSample and DataSet created for the corresponding DataSource. Step 15 Load the ConnectionString from the Applications Web.config file. Step 1 Create the parameter Parameter --> Right Click --> Add Parameter --> Add the Name of the parameter Click OK. Step 2 We can change the properties of the Datasource by right clicking the DataSource --> Properties. Click the Expression button (Image with fx). Subsequently, add the parameter value as the Connection String. Click OK. The connection string will be looked, as shown below. Click OK. The value of the parameter will be passed from the Web Application as the report parameter. ------------------------------End-------------------------------------------- Output
Introducing Microsoft SQL Server 2014