1 / 19

Introduction to Building Reports

Introduction to Building Reports. Reporting Services. Thank You Event Sponsors. Please visit them and inquire about their products & services To win prizes make sure to get your bingo card stamped by ALL sponsors. Dimitri Ayrapetov. SharePoint Technical Consulting Lead, N.A.

timon-boyer
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 Reporting Services

  2. Thank You Event Sponsors Please visit them and inquire about their products & services To win prizes make sure to get your bingo card stamped by ALL sponsors

  3. Dimitri Ayrapetov • SharePoint Technical Consulting Lead, N.A. • @ Cognizant Technology Solutions • Working with SharePoint since 2005 • Working with SQL Server since 2004

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

  5. What is SQL Server Reporting 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”. • Add-in that lives within a shell of Visual Studio 2013. • 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 since 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

  10. Report Processor

  11. Presentation Layer SharePoint Mode • Report Definitions are published to a SharePoint Library • Permissions to open 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. SSRS 2014 Installation (SharePoint Integrated Mode) • App Server Installation • Run the SQL Server 2014 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)

  13. Integration with SharePointSQL Server 2012 and 2014

  14. Integration with SharePointPrior to SQL Server 2012

  15. SharePoint and SSRS Version Mix & Match Source: http://msdn.microsoft.com/en-us/library/gg492257(v=sql.120)

  16. Security & Permissions

  17. Demo

  18. Additional Resources SSRS Team Blog http://blogs.msdn.com/b/sqlrsteamblog/ TechNet: SSRS 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

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

More Related