Configuring Users - best Practices

Hello All,
I need to find out the best practices approach for user configuration in SQL
Reporting Services. I have teams of developers, who would be using VS.NET
development and deploying using VS.NET. Whats the best approach I could take
for development...Ideally I would like each team of users to have a folder
and so that they could deploy the reports only to those folders. Also how do
I set VS.NET to deploy a specifc sub folder.
Any thoughts or suggestions would be of good help.
Thanks,
ChrisYou can't deploy to a SubFolder in RS2K. Deployment from VS takes your
project name and uses it when you deploy. Only get one level.
There is a My Report folder you can turn on using the Report Manager under
system settings, but not sure that'll help you solve the problem you've
described.
If you need more, most straight forward approach is to go into Report
Manager after you deploy and move things around. Either that or use Report
Manager to 1st create the directory structure (folders / subfolders)
desired, then as Content Manager use the Upload File button on the tool bar
from within the subfolder to upload your reports.
If you find this to be burdensome, perhaps consider creating a VB script
like the one at
http://msdn.microsoft.com/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
to automate the deployment process. Note, you could also do this
programmatically using the RS2K SOAP API. Perhaps as a program or daemon
that traverses a directory structure looking for .rdl files and then creates
the equivalent folders in RS to upload the reports to.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Christopher Pragash" <chrispragash@.hotmail.com> wrote in message
news:uyCnuc6mEHA.1304@.TK2MSFTNGP09.phx.gbl...
> Hello All,
> I need to find out the best practices approach for user configuration in
> SQL
> Reporting Services. I have teams of developers, who would be using VS.NET
> development and deploying using VS.NET. Whats the best approach I could
> take
> for development...Ideally I would like each team of users to have a folder
> and so that they could deploy the reports only to those folders. Also how
> do
> I set VS.NET to deploy a specifc sub folder.
> Any thoughts or suggestions would be of good help.
> Thanks,
> Chris
>|||John H. Miller wrote:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
I don't think that's correct, John. I am able to deploy to any folder I
want in RS2K (SP1) by setting the TargetFolder property under Deployment in
the project's Property Pages.
I would think Chris could set up a separate folder for each developer and
set up permissions that allow a developer to publish only to his/her own
folder. Each developer would simply set the TargetFolder to the virtual
path to his/her folder.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Christopher Pragash wrote:
> Hello All,
> I need to find out the best practices approach for user configuration
in SQL
> Reporting Services. I have teams of developers, who would be using
VS.NET
> development and deploying using VS.NET. Whats the best approach I
could take
> for development...Ideally I would like each team of users to have a
folder
> and so that they could deploy the reports only to those folders.
you can:
* create separate security groups containing the various teams of
developers
* create the various target folders on the report server
* assign the pertinent security group to the 'Content Manager' role
(using Report Manager is the easiest way to do this)
the above assumes all users are in a single domain and that you have
the ability to create groups. if not, you can use report manager once
again to create the folders and then add each developer individually to
the content manager role.
> Also how do I set VS.NET to deploy a specifc sub folder.
once you have created a BI project in the VS designer, you right-click
the project and select properties. from there, you can figure the
appropriate subfolder to deploy to, as well as the target server.
hope this helps.
cheers,
~stuart|||John H. Miller:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
Jake Marx:
<< I don't think that's correct, John. I am able to deploy to any
folder I
want in RS2K (SP1) by setting the TargetFolder property under
Deployment in
the project's Property Pages. >>
Jake is correct. You can set the targetfolder property to be
arbitrarily deep. if the directory structure doesn't exist, it will be
created on the first deploy.