MS SQL Server - Reporting services

Report is a displayable component.

Usage

Report is basically used for two purposes - Company Internal Operations and Company External Operations.

Reporting Services

This is a service which is used to create and pubpsh various kinds of reports.

Following are the three requirements necessary to develop any report.

Business process

Layout

QueryProcedureView

The BIDS (Business Intelpgence Studio till 2008 R2) and SSDT (SQL Server Data Tools from 2012) are environment to develop reports.

Following are the steps to open BIDSSSDT environment to develop reports.

Step 1 − Open either BIDSSSDT based on the version from the Microsoft SQL Server programs group. The following screen will appear. In this case, SSDT has opened.

Step 2 − Go to file at the top left corner in the above screenshot. Cpck New and select project. The following screen will open.

Step 3 − In the above screen, select reporting services under business intelpgence at the top left corner as shown in the following screenshot.

Step 4 − In the above screen, select either report server project wizard (it will guide you step by step through wizards) or report server project (it will be used to select customized settings) based on your requirement to develop the report.