Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Video

VIDEO – Tour of SSRS, PowerPivot, and PowerView

I wanted to record an introduction to the new reporting and Business Intelligence capability within SharePoint 2013.   After loading SP2013, there are a few steps to activate the backend Service Applications for BI.   The SQL 2012 install media is needed for this to install SSRS Integrated Mode and PowerPivot.

However, once those are online you can load great samples like “PowerView – Hello World Picnic” to browse real data and confirm it all works correctly.   Very cool stuff, enjoy!  

Smile

References

 

SSRS-PowerPivot-PowerView from Jeff Jones on Vimeo.

VIDEO – How to test SSRS 2012 (map of US states)

Check out the below video to learn how to test SQL Server Reporting Services.  After installing to Central Admin with the steps from http://msdn.microsoft.com/en-us/library/jj219068.aspx  I wanted to see a real report to confirm successful install.    A simple SharePoint list with US state postal abbreviations connects to RDL with Map Wizard and is a great way to show the full pipeline works correctly:

  • SSRS Service Instance (on server)
  • SSRS Service Application (on farm)
  • Authentication (C2WTS or Kerberos)
  • Site Feature (PowerView Integration)
  • Site Content Types  (Report Builder Model – SMDL, Report Builder Report – RDL, Report Data Source – RSDS)
  • Report Builder 3.0  (web deploy click once)
  • RDL web rendering engine
  • Export to PDF  web actions menu

If you find this helpful, please leave a comment and I’ll try to do more videos. 

Smile

 

How to test SSRS 2012 on SP 2013   (length 7:12) from Jeff Jones on Vimeo.

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲