Groups | Blog | Home
all groups > sql server reporting services > november 2005 >

sql server reporting services : Best practices for multiple report developers?


Al
11/3/2005 1:39:05 PM
Two crystal reports developers are about to join me writing reports for
Reporting Services. Neither has used RS before and I don't believe either
has ever used Visual Studio.

I am concerned about what will happen when they build/deploy a project.
Will we end up with multiple unwanted folders and data sources? I thought
maybe we could all use copies of the same solution but I also want to use
SourceSafe and i dont want to worry about checking different versions in on
top of each other.

I would really like something like Visual InterDev 6 where multiple
developers connect their own solutions to a web application and all of the
resources are visible (asp, html, css, js, jpeg, gif, etc..) Is there a good
way to do this with the Report Designer?

Any thoughts or links regarding multi-developer coordination issues would be
Al
11/3/2005 2:26:11 PM
Is it possible for the Report Designer to "download" or otherwise learn about
the available shared data sources or is the only way to add the *.RDL file to
the project?

Thanks!

PS: Sorry for all the duplicates, I goofed up while trying to sign up for
passport at the same time as writing my question.


[quoted text, click to view]
Bruce L-C [MVP]
11/3/2005 5:13:46 PM
I always use shared data sources. Once a shared data source is deployed it
is not overwritten unless you explicitly do so. When you deploy it will try
to deploy the data source, see that one is there and just give you a warning
that it was not deployed.

If you decide on the folder structure and name your projects the same, then
you should not have a problem (as long as you don't name the reports the
same.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Ches Weldishofer
11/4/2005 7:05:14 AM
If you've made shared data sources you should have an .rds file which
is the actual data source.

Once it's been migrated to the rs server it doesnt' get updated unless
it's deleted or someone explicitly updates it, so for developing local,
we've just emailed the rds to each other. ( you can find it in My
documents/Visual Studio Projects/ProjectName... or if you're using
source safe they should be able to grab a copy from there)
Dan Costello breadbelt.com
11/18/2005 11:31:04 AM
On Shared Data Sources, there is also a flag in the Properties
Pages/Configuration Properties/General for "OverwriteDataSources" which
defaults to False. Just make sure no one sets that to True or else you WILL
overwrite your data sources in deployments.

[quoted text, click to view]
AddThis Social Bookmark Button