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

SQL 2014 and SSRS Integrated “Hello States.rdl”

Recently I create a new lab virtual machine with SharePoint 2013 and SQL 2014 to test SSRS Integrated mode.  

 

I found the screenshot based instructions at http://rajeshagadi.blogspot.com/2013/07/installing-reporting-services-in.html even more helpful than TechNet official documentation http://msdn.microsoft.com/en-us/library/jj219068.aspx.     Both are good and make configuration easier.   Also I needed to follow the C2WTS configuration steps http://msdn.microsoft.com/en-us/library/hh231678.aspx and Kerberos steps http://technet.microsoft.com/en-us/library/gg502594.aspx to enable single sign on for Claims authentication and SSRS Integrated mode.   To enable SMTP and IMAP email routing I followed https://www.spjeff.com/2011/02/05/how-to-free-internal-sharepoint-email-imappopsmtp-inbound-and-outbound/ to configure both IIS 6.0 inbound to SharePoint and HMailServer SMTP/IMAP for end user mailboxes.

 

With SSRS online the next task was to build a sample report.  Below are the steps I followed.  

In the end we have a nice graphical USA map with data points coming from SPList.  Enjoy the screenshots!   

shades_smile

 

  1. Open SP2013 Team Site
  2. Create new list named “States” with columns “Title” and “Number”
  3. QuickEdit to add a few sample rows
  4. Activate “PowerView” site collection feature
  5. Add SSRS Content Types to a library
  6. Launch Report Builder 3.0
  7. Create a map with wizard
  8. View in IE to test
  9. Schedule daily job to run report and email PDF
  10. View PDF

 

image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲