Call us today to see how we can help you be at your best.
SQL Server Reporting Services(SSRS) is becoming an integral component of any business today. Many of our clients have sites with hundreds of SSRS Reports. SharePoint 2010 with SSRS in Integrated mode simplifies the configuration and management of SSRS Reports by allowing many of the administration tasks to be configured through SharePoint. However there is one large caveat.
When using Shared Data Sources setting the Report Data Source URLs is a manual and tedious procedure which has to be configured one report at a time. One can imagine that a site with a hundred reports can take a considerable amount of time.
Furthermore, there are a number of scenarios where the Data Source information needs to be reconfigured:
We have created two PowerShell scripts which will aid in this process:
Get-SSRSDataSourceInfo will iterate through all the reports in a Document Library and display the Data Source URLs for every Data Source. Simply run the function with a Document Library URL as the parameter.
Set-SSRSDataSourceInfo will set the Data Source URL for every report in a Document Library. Simply run the function with a Document Library URL, Data Source Name and Data Source URL parameters.
If you have any questions please leave a comment.
Sign up today to receive our monthly newsletter with tips, Microsoft funding availabilites, upcoming events and industry news.
Ready to celebrate the year with us?
Softlanding is hosting their third annual Open House party at our downtown office. Join us for an evening of cocktail party hors-d'oeuvres, drinks, live music with I M U R, prize draws, and photo booth fun!
Sign-up to our monthly newsletter for valuable insights, workshops/events and funding available for your next project!