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!
- Open SP2013 Team Site
- Create new list named “States” with columns “Title” and “Number”
- QuickEdit to add a few sample rows
- Activate “PowerView” site collection feature
- Add SSRS Content Types to a library
- Launch Report Builder 3.0
- Create a map with wizard
- View in IE to test
- Schedule daily job to run report and email PDF
- View PDF