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. • @ Cognizant Technology Solutions • Working with SharePoint since 2005 • Working with SQL Server since 2004
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
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.
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.
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)
SharePoint and SSRS Version Mix & Match Source: http://msdn.microsoft.com/en-us/library/gg492257(v=sql.120)
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
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