Dynamic Shared Data Source

• BSavoie

  SSCertifiable

  Points: 6309

  More actions

  November 2, 2009 at 10:57 pm

  #227689

  Is there any way to specify the name of a shared data source at runtime? I've been down the dynamic connection string road, and I'm not so crazy about that. Mostly because it simply fails in this specific project. I'm sure I can figure that part out eventually, but it sure seems like I should be able to specify the name of a shared data source at runtime since they are so much easier to manage.

  Using SqlServer 2008. I'm rendering my report in an ASP.Net 3.5 web page app using the Microsoft Report Viewer control.

  .

• carlos5686

  SSC Journeyman

  Points: 96

  More actions

  March 31, 2012 at 8:39 pm

  #1467375

  You can look at this article:

  Dynamically Pointing to Shared Data Sources on SQL Reporting Services using a Report Definition Customization Extension (RDCE)