Training

SQL Server 2008

Home >> Courses Offered >> SQL Server Reporting Services

Introduction
SQL Server Reporting Services (SSRS) is a server-based report generation software system. SSRS is used to prepare and deliver a variety of interactive and printed reports. It is administered via web interface. Reporting services feature web services interface to support the development of custom reporting applications. It can be used to prepare and deliver a variety of interactive and printed reports. SSRS is capable of generating reports in various formats such as the web-oriented Hypertext Markup Language (HTML) and desktop application (Microsoft Excel and CSV) formats, thus allowing users to manipulate data in required format. In addition, SharePoint can be used as a front end for SSRS, allowing reports to be presented directly in corporate portals.

Objectives
The objectives of this SSRS tutorial are:
  • To learn Business Reporting Concepts
  • To learn Reporting fundamentals
  • To understand how to become SSRS developer
  • To learn SSRS Reports development life cycle
  • To learn SSRS Architecture
  • To learn Creating and Publishing a Report
  • To learn Creating Report Parameters
  • To learn working with Cascading Parameters
  • To learn working with Drill-Down reports
  • To learn working with Matrix Reports
  • To learn working with Report Caching
  • To learn working with Subscriptions
  • To learn working with Snapshots
Audience & Pre-requisites
This SSRS tutorial is helpful for the candidates who would like to learn SSRS from basics or who have prior experience with any other Reporting tools. Students should be familiar with database concepts and experience on any other database system would be an added advantage.

Course Outline
    • Overview of Reporting Fundamentals
    • Overview of SSRS
    • Using BIDS
    • Working with Data Sources
    • Working with Shared Data Sources
    • Working with Expressions
    • Working with Groups
    • Working with Subtotals
    • Working with Drill-Down Reportrs
    • Developing Code using Script Tasks
    • Working with Report Parameters
    • Working with Multi-valued Parameters and Cascading Parameters
    • Working with Matrix Reports
    • Working with Chart Control
    • Working with Report Security
    • Programming Reporting Services
    • Snapshots and Subscriptions
    • Deployment

Why should you choose Deccansoft?


For further information, please fill the enquiry form .


Dates & Locations
For regular batches at Deccansoft Click Here..

For Corporate training submit request

LiveZilla Live Help