1 / 21

Introduction to Building Reports

Introduction to Building Reports. Dimitri Ayrapetov December 11, 2013. Reporting Services. Dimitri Ayrapetov. SharePoint Solutions Architect @ EMC Professional Services In the Digital Workplace Practice Working with SharePoint since 2005 Working with SQL Server since 2004.

kemal
Download Presentation

Introduction to Building Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Introduction to Building Reports Dimitri Ayrapetov December 11, 2013 Reporting Services

  2. Dimitri Ayrapetov • SharePoint Solutions Architect • @ EMC Professional Services • In the Digital Workplace Practice • Working with SharePoint since 2005 • Working with SQL Server since 2004

  3. Digital Workplace Practice Summary of SharePoint / SQL / FAST Credentials 22 time Regional & Global Recognition

  4. Agenda • What is SQL Server Reporting Services (SSRS)? • Brief History • SSRS Components • Installation Overview • Integration with SharePoint • Security & Permissions • Demo – Basic Report • Demo – Report Enhancements • Additional Resources • Q & A

  5. What is SQL Server Reporting Services? • A core component of the SQL Server family • Used to present data in a meaningful way • Consists of a set of tools and services

  6. Brief History

  7. SSRS Components

  8. Report Designers • SQL Server Data Tools • The only Report Development Tool that can access the full suite of available functionality within SSRS. • Previously known as “Business Intelligence Studio”. • Lives within a shell of Visual Studio 2010. • Report Builder 3.0 • Basic Editor geared towards enabling Power Users with the ability to build basic reports with pre-established boundaries. • Maintains UI similar to Office 2007. • Power View • New feature with SQL Server 2012 to provide an interactive data exploration, visualization, and presentation experience. • Great for building ad-hoc reports on the fly.

  9. Report Definition MyReport.RDL

  10. Report Definition Data Connections

  11. Presentation Layer • SharePoint Mode • Report Definitions are published to a SharePoint Library • Permissions to access the report definition are based on SharePoint permissions • Note: Permissions to access the data behind the report is often different than permissions to access the report definition itself • Reports are rendered within SharePoint • Native Mode • Installs a basic ASP.net Application to an IIS Site to handle navigation, permissions, report repository, etc. • Note: Upon installing SSRS from your SQL Server Media, you will be prompted to use Native Mode or SharePoint Mode. Once you make a selection, you cannot change it without reinstalling SSRS. However, reports can be migrated from one instance of SSRS to another regardless of deployment mode.

  12. Report Processor

  13. SSRS 2012 Installation (SharePoint Integrated Mode) • App Server Installation • Run the SQL Server 2012 installation and only install the “Reporting Services – SharePoint” feature • Web Front End Installation • Install the Reporting Service add-in for SharePoint • The add-in can be found on the SQL installation media or downloaded from Microsoft • Configuration • Navigate to Central Admin > Services on Server • Start the “SQL Server Reporting Services Service” on the appropriate App Servers • Create a “SQL Server Reporting Services Service Application” and associated with your Web App(s)

  14. Integration with SharePoint Prior to SQL Server 2012

  15. Integration with SharePoint SQL Server 2012

  16. Security & Permissions • There are 2 layers of security with SSRS and SharePoint: • The 1st layer is within the SharePoint library. Unless you have appropriate permissions, you will not be able to access the report, or even know that it exists. • The 2nd layer can be set within your report’s connection to your data source, which can restrict the data that the user can see.

  17. Security & Permissions

  18. Demo

  19. Additional Resources • SSRS Team Blog • http://blogs.msdn.com/b/sqlrsteamblog/ • TechNet: SSRS 2012 • http://technet.microsoft.com/en-us/library/ms170438.aspx • TechNet: SSRS Tutorials • http://technet.microsoft.com/en-us/library/bb522859.aspx • MSDN: SSRS • http://msdn.microsoft.com/en-us/data/ff660783.aspx

  20. Wrap Up • Thank you for attending! • Q & A • This deck and project files can be found on my new blog: http://dimitri.spgurus.com • Follow me on my new Twitter: @dayrapetov • Connect on LinkedIn: linkedin.com/in/dimitriayrapetov/ • Email me: Dimitri.Ayrapetov at EMC.com

More Related