SQL Server Performance

Datasources ?

Discussion in 'SQL Server 2005 Reporting Services' started by acki4711, Jan 26, 2010.

  1. acki4711 Member

    Hi all have a Reportserver and another development machine.
    Building a new report on development machine includes building a datasource to my database.
    When I deploy the newly created report to the reportserver the datasource id won't work because on ReportServer there is a different Datasource (same Name but different id).
    How to avoid the manaul step changing the datasource id in the .rdl file manualy before deploying report to report server?
    Do I need to deploy the .rds file as well ?? Or what's the idea??
    Thanks for any help.
  2. acki4711 Member

    OK, sutpid question, I'll answering myself..
    - deploy datasource file (.rds) as well
    - or modify id of datasource on development machine with those id from report server
    Somtimes trying to explain a problem to someone else solves the problem....
    Cheers to myself :)
  3. FrankKalis Moderator

    As an additional safety measure in the Report project properties I have specified "OverwriteDataSources" = FALSE. So that I don't accidentally overwrite the production datasource with with development one or vice versa, etc...

Share This Page