Login   Register 
Receive news via our XML/RSS feed
Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles
  • Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
    Creating an SSL Certificate to ensure your confidential reports remain confidential


  •  
    Beta V Corporation
     
     
    SQL Reporting Services - Answers to your questions
     
    Author Thread: Reporting Services Deployment Question
    Matt.Riley

    Reporting Services Deployment Question
    Posted: Tuesday, March 03, 2009 1:18 PM (GST)

    Hi,

    I have developed a number of reports for my business and need to deploy them in a certain manner.

    We have 200+ stores and each store needs to see the same report but containing that store data only.

    The data has a Store ID within. We cannot allow store 123 for example to view store 67's data.

    All users from each store are within an AD group for their store such as Store123.

    I want the end user to be able to run the report and for only their store data to be shown. I may be reading the books wrong but it seems like i have to deploy 200 copies of the report in 200 folders with custom parameters and then give the AD group permissions to view that folder.

    Is there a quicker way of doing this?

    Kind Regards,

    Matt Riley

     

     
     
     
     
     
    Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About