Sql Server Reporting Services(SSRS) in Project Server

SQL Server Reporting Services(SSRS) in Project Server:-

SQL Server Reporting Services(SSRS) in Project Server. SQL Server Reporting Services (SSRS) is a server-based report development software.SSRS is a Microsoft SQL reporting, that helps you to create, deploy and manage reports. In this reporting tool, we use Microsoft SQL server, fetch the required data to creating the connection. After creating the connection create the graphical design. All these reports can be viewed via a web browser.

Step 1: Open SQL Server Data Tool. (Click for downloading SSRS Tool)
Step 2: Click On File>New>Project>Select Report Server Project.
Sql Server Reporting Services

Sql Server Reporting Services
Step 3: Click on Reports folder and select Add New Report. Report Wizard will be open, Click on Next button.

[AdSense-A]

Sql Server Reporting Services

Sql Server Reporting Services
Step 4: Now create the database connection to report. Click on Edit button

Sql Server Reporting Services
Step 5: Define Connection Properties, Select Server Name and Database Name, Test connection and click OK

Sql Server Reporting Services
Step 6: Connection created successfully. Go to query builder wizard to click on Next.

Sql Server Reporting Services
Step 7: Paste Required SQL query here check data to click on Query Builder.

Sql Server Reporting Services
Step 8: When you click on next a Report wizard of Select The Report Type will appear, Select the Report Type you want to Show to the user and Click on Next.

[AdSense-A]

Sql Server Reporting Services

Step 9: ==============

Sql Server Reporting Services

 

Step 10: Choose the Table style as u want to show report format color.

Sql Server Reporting Services

 

Step 10: Type Report name in Report Name section.

SSRS_Report_12

 

Step 11: Click to Next button, Your Report is here now you can design according to you.

SSRS_Report_13

 


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

error: Content is protected !!