未加星标

Getting Started with SSRS 2016 - Part 2

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二04 | 时间 2017 | 作者 红领巾 ] 0人收藏点击收藏

Prerequisite

We should have some basic knowledge in SQL Server Query and Visual Studio Tool for creating an SSRS Reports using Visual Studio 2015.

SQL Server Basic Query Visual Studio 2015

How to setup the SSRS Environment

If you want to know how to setup the SSRS Environment procedure, prerequisite and SSDT, please you can read out my previous article as below link

Getting Started with SSDT 2016 using Visual Studio 2015

How to create a Table in database

Firstly, You can create a Student table using SQL Server Management Studio in SQL Server database.Then, you can add student record in the Student table.

create table Student ( StudentId int primary key , StudentName varchar ( 20 ), StudentCourse varchar ( 20 ), StudentFees money , StudentDOB date , StudentStatus varchar ( 20 )

)

select * from Student

Insert into Student values ( 1 , 'Santhakumar' , 'DotNet' , 15000 , CONVERT ( date , '11/06/1982' ), 'Active' )

How to Create an SSRS Project

Open Visual Studio 2015. Go to File menu, point to new and click new project. New Project Window will open, you can select an installed template like “Reporting Services” in Business Intelligence Template and then select the Report Server project and type Project Name StudentReport. Choose the project location path and click OK button


Getting Started with SSRS 2016 - Part 2

The Report Wizard window will open and click the Next button


Getting Started with SSRS 2016 - Part 2

The Select the Data Source window will open and click the Edit button


Getting Started with SSRS 2016 - Part 2

The Connection Properties window will open and type the Server Name, Select the Authentication, User Name, Password, Select or Enter a database name and finally you can check the database connection succeed, followed by clicking the Test Connection button. Then Click the OK button.


Getting Started with SSRS 2016 - Part 2

The Select the Data Source window will open and select the new data source, connection string and click the Next button


Getting Started with SSRS 2016 - Part 2

The Data Source Credentials window will open and type the User Name, Password and Click the OK button.


Getting Started with SSRS 2016 - Part 2

The Design Query window will open and clicking the Query Builder


Getting Started with SSRS 2016 - Part 2

The Query Designer window will open and type the query in which table you want to load the report and executing the SQL query, followed by clicking the SQL icon.


Getting Started with SSRS 2016 - Part 2

The Query Designer window will open and loaded the SQL statement for the particular table and click the OK button.


Getting Started with SSRS 2016 - Part 2

The Design Query window will look with SQL query as shown in the following screenshots


Getting Started with SSRS 2016 - Part 2

The Report Type window will open and select the report as Tabular and click the Next button.


Getting Started with SSRS 2016 - Part 2

The Table design window will open and adding table columns to display fields, followed by clicking Details button. Then click the Next button.


Getting Started with SSRS 2016 - Part 2

The Completing Wizard window will open and type the Report Name and click the Finish button.


Getting Started with SSRS 2016 - Part 2

After creating SSRS project report, you can see the solution explorer structure, as shown in the following screenshot


Getting Started with SSRS 2016 - Part 2

Now, you can see the report design view as following


Getting Started with SSRS 2016 - Part 2

How to deploy the Report

Go to the Solution Explorer, point the StudentReport project and right click the StudentReport and point to deploying Student Reports, then click the deploy context-menu item.


Getting Started with SSRS 2016 - Part 2

After successfully deployed the report to Report Server, you will see the information from the output window as shown in the screenshot


Getting Started with SSRS 2016 - Part 2

How to run the Report

You can see in details how to run the Report using Report Server in the Browser. You can see the step by step procedures as below

Firstly, you have to copy the default Report Server Url and paste the same Url into your browser for the run report application.

http://localhost/reportserver


Getting Started with SSRS 2016 - Part 2

Now, you can run the report application, followed by StudentReport project and clicking the StudentReport


Getting Started with SSRS 2016 - Part 2

Conclusion

I hope you understood how we can create an SSRS Report using Report Wizard in SQL Server Reporting Services 2016, How to deploy/run the report application in the Report Server. I have covered all the required things. If you find anything which I missed in this article, please let me know. Please share your valuable feedback or comments and suggestions to improve future articles.

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

分页:12
转载请注明
本文标题:Getting Started with SSRS 2016 - Part 2
本站链接:http://www.codesec.net/view/531661.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(33)