100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 10 out of 103 pages.
Advanced .NET Server DevelopmentReportingInstructor: Mahboob Ali
Objectives •Intro to Reporting•Capstone Reports•Intro to SQL Server Reporting Services (SSRS)•Report Manager•Intro to Report Authoring•Building Reports
Introduction to Reporting•Reporting is about analyzing large sets of data, transforming the data and presenting it to the user in a way that facilitates business decisions•Reporting is a major part of what is now commonly referred to as “Business Intelligence”•Reporting is very important for businesses as it allows:Understand the current state of the business (customers, sales, products, inventory, suppliers, purchases, financials, etc.)Identify trends in business•Reporting is very important for Capstone Projects
Report VS Data Dumps•A standard Order List that lists every sale in the Orders table is NOT a Report. This is a Data Dump!Would you want to manually analyze every order on Amazon for the past month to assess how the business is doing?How about reviewing each entry of the Toronto phone book and manually collecting statistics?
SQL Reporting Services (SSRS)•What is?SQL Server Reporting Services is a server-based report generating software system from Microsoft.•What Report Services?Three different types of report servicesTraditional “Paginated” reports.Mobile reports.Web Portal reports.
Introduction to SQL Server Reporting•There are several tools for SQL Server Reporting•The two most common are:Crystal ReportsSQL Server Reporting Services (SSRS) •Crystal Reports was very popular for SQL Server Reporting for many years was included for free with Visual Studio for many years up until VS 2010•Microsoft has invested heavily in SQL Server Reporting Services (SSRS) recently and it has become the most popular Reporting option for SQL Server
Introduction to SQL Server Reporting•SSRS is a component of SQL Server which may be installed on the same machine as SQL Server•A powerful but limited version of SSRS is included with SQL Server Standard, Web and “Express with Advanced Services” 2012 editions•The full version of SSRS is included with Enterprise and Business Intelligence editions of SQL Server 2012•SSRS is typically sold as an add-on for Web hosting packages OR as part of a more expensive hosting package.
Introduction to SQL Server Reporting•Web Browser for retrieving reports•Report Manager provides a web portal for accessing and managing reports•Report Builder and Report Designer are used for designing reports•Report Server to generate reports•Web Service for programmatic access to reports•Data Source (SQL Server, Oracle, etc.) for the data
Traditional Paging Reports•Ideal for fixed-layout documents, optimized for printing, such as PDF and Word files.