As part of configuring SSRS in SharePoint 2013 we need to create data source create connection string for SSRS report. In order to do that we need add “Report Data Source Content Type” to a document library in SharePoint 2013. The same way we can resolve the report server integration feature missing sharepoint 2016 issue. The solution will work for SharePoint 2016 and SharePoint 2013.
When I was trying to attach / associate Report Data Source content type to document library I don’t that as part of list of content types at site collection level.
Please follow below steps to get Report Data Source content type.
– Navigate to Site Settings
– Click on Site collection Features
– Locate “Report Server Integration” feature deactivate and activate the feature
– Now if you try to associate the content type you can 3 new content type
1. Report Builder Model
2. Report Data Source
3. Report Builder Report
– Now you can see 3 different option when you click on new item in document library
Hope this helps, happy reporting in SharePoint 2013.
I am Krishna.Vandanapu a SharePoint architect working in IT from last 12 years, I worked in SharePoint 2007, 2010, 2013, 2016 and Office 365. I have extensive hands on experience in customizing SharePoint sites from end to end. Expertise in SharePoint migration tools like Sharegate, Doc Ave and Metalogix. Migrated SharePoint sites from SharePoint 2007 to 2010 and 2010 to 2013 several times seamlessly. Implementing CSOM with Microsoft best practices. Spent quality time in configuring SharePoint application services like User Profile, Search, Managed Meta data services etc. Now exploring SharePoint Framework and SharePoint 2019