Scenario:
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.
Issue:
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.
Solution:
Please follow below steps to get Report Data Source content type.
– Navigate to Site Settings
– Click on Site collection Features
New to Office 365 SharePoint Online? Get Office 365 Enterprise E3 Subscription & Try out all the 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.
