shared datasource in reports sql server 2005

  • hello,

    help me,

    I cant understand to connect shared datasource in reports.

    Thanks you.

    Dastagiri.D

    Thanks
    Dastagiri.D

  • In SSRS, shared databse means: a datasource can be used in many reports.

    otherwise you can create different datasource for each report.

  • hello,

    how can I connect this shared datasource. Im my reports.

    It is for used any command are any cofigurations is there?

    thank you

    Dastagiri.D

    Thanks
    Dastagiri.D

  • There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change a single report / model or allow bulk changes for many reports and models.

    There is also a health check feature, to detect and correct reports and models that have missing data sources. Multiple data sources for reports and models are also supported.

    http://www.lecomputing.com/ssrsdatasourcemanager.html

    Other uses can be- changing a selection of reports to another data source, eg moving from UAT/Development to production, or server loading issues.

  • Shared data sources enables report developers to use a datasource that is already created and exists within the related reporting services project.

    This makes it easier to maintain the reports.

    For example if you are developing your reports by connecting a development SQL server, then by changing only one datasource object on the production site, your reports will work with production database.

    Please check the article titled Creating a Shared Data Source

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply