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. TIA acki4711
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
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...
