"toolman" <timd@infocision.com> wrote in message
news:1140542269.892445.30270@g14g2000cwa.googlegroups.com...
>A little background first. We have two IT divisions, each of those
> break down to at least four subdivisions. Some of those subdivisions
> break down even further. Each division, sub and sub-sub has reports
> specific to their area. It becomes very complicated and the volume of
> reports is large and growing.
> Because of the complicated hierarchy and the volume we actually
> maintain two separate instances of Report Manager on two separate
> boxes. One for Development the other for Production.
> All developers have almost Content Manager rights to folders and
> reports on the development server. End users get Browser access to
> this box on a need be basis.
> General permissions on the production server are much more limited,
> pretty much just to the Browser role. We have a group of individuals
> ("Admins") with Content Manager rights who do all the report management
> on the production box.
> In conjunction, we also maintain two separate, Development and
> Production project folders in Source Safe. The Admins move production
> ready projects from the Dev folder to the Prod folder and deploy from
> there.
>
> All that being said, depending on your situation you could probably
> accomplish much of the same with a folder hierarchy using the role
> based item level security features of SSRS.
>

"Steven" wrote:

> Thank you that quick answer. I am curious how objects are moved though.
> The process of moving to Production should be handled by a select few. What
> kind of process exists within Reporting Services to move objects
> (folders/data sources/reports/etc.)?
>
> Thanks,
>
> Steve
> "toolman" <timd@infocision.com> wrote in message
> news:1140542269.892445.30270@g14g2000cwa.googlegroups.com...
> >A little background first. We have two IT divisions, each of those
> > break down to at least four subdivisions. Some of those subdivisions
> > break down even further. Each division, sub and sub-sub has reports
> > specific to their area. It becomes very complicated and the volume of
> > reports is large and growing.
> > Because of the complicated hierarchy and the volume we actually
> > maintain two separate instances of Report Manager on two separate
> > boxes. One for Development the other for Production.
> > All developers have almost Content Manager rights to folders and
> > reports on the development server. End users get Browser access to
> > this box on a need be basis.
> > General permissions on the production server are much more limited,
> > pretty much just to the Browser role. We have a group of individuals
> > ("Admins") with Content Manager rights who do all the report management
> > on the production box.
> > In conjunction, we also maintain two separate, Development and
> > Production project folders in Source Safe. The Admins move production
> > ready projects from the Dev folder to the Prod folder and deploy from
> > there.
> >
> > All that being said, depending on your situation you could probably
> > accomplish much of the same with a folder hierarchy using the role
> > based item level security features of SSRS.
> >
>
>