SQL Report

we Must be provaid satisfaction Services in Our Application

SQL Server Reporting Service

SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization. Reporting Services includes programming features that enable you to extend and customize your reporting functionality.

Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components.

  • Reporting Services Components.

  • Install Reporting Services.

  • Business Intelligence Development Studio (BIDS) .

  • Install Sample Database.

  • Create a Simple Report with the Wizard.

  • Create a Simple Report with the Report Designer

  • Deploy Reports.

  • Configure Report Manager Security.

SQL Server Analysis Service

SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.

Services steps
  • 1. Click Start, point to All Programs, point to Microsoft SQL Server 2012, and then click SQL Server Data Tools.

  • The Microsoft Visual Studio development environment opens.

  • 2. On the Start page of Visual Studio, click New Project.

  • 3. In the New Project dialog box, in the Installed Templates pane, expand Business Intelligence, and then select Analysis Services. Choose the Analysis Services Multidimensional and Data Mining Project template.

  • Notice the default project name, location, and the default solution name are generated in the bottom of the dialog box. By default, a new directory is created for the solution.

  • 4. Change the project Name to Analysis Services Tutorial, which also changes the Solution name box, and then click OK.

SQL Server Integration Service

SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data. While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just DW; e.g. when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created. At a high level, SSIS provides the ability to:

  • retrieve data from just about any source.

  • perform various transformations on the data; e.g. convert from one type to another, convert to uppercase or lowercase, perform calculations, etc.

  • load data into just about any source & define a workflow.

  • Creating SSIS packages with SQL Server Management Studio (SSMS).

  • Business Intelligence Development Studio (BIDS).

  • Creating a simple SSIS package in BIDS, Deploying SSIS packages & Executing SSIS packages.