In BIDS, I've created a sales report for 300 Territories across the US. The data is from a data warehouse and is always 1 day old. For server efficiency and user performance, I would like to create the report once in the morning after the ETL is finished, then when users access it in Report Manager it will filter out only their territory and display the results without hitting the database. I store the Active Directory UserID in a table with the proper territory_id. territory_id UserID 17 KHOOTON 19 MSOMOSKY 1A DSCHULTZ2 1C KGAIL 1D GRHEINGR 1E BHaberly The sales report's only parameter is the territory_id and I present sales data from the beginning of the month to yesterday. I've been experimenting with User!UserID in expressions in the dataset filter as this returns the AD User (in my case VISTA\pmetcalf). I can carve off the domain and have an exact match to my UserID field. I am currently trying to create this in an Execution Snapshot. I see this as a 2 step process. Create a snapshot containing all data for all territories When a user selects the report, filter out only their territories. I can either do one or the other, but not both. * please spell check your technical posts *

Hi Guitarzan8, According to your description, you would like to create a snapshot containing data for all territories, but when user selects the report, they only can see the their own territories, right? Please correct me if my understanding is wrong. If that’s the case, I am afraid it cannot be achieved by using snapshot. In contrast with reports that run on demand, it is not possible to specify a different parameter value for a report snapshot once the report is open. Choosing a different parameter value would result in a new report processing request, which is not allowed. So I suggest you creating a data-driven subscription to achieve your target. Data-driven subscriptions are dynamic in that the presentation, delivery, and parameter values are retrieved at run time from a data source. You might use data-driven subscriptions if you want to vary report output for each recipient. To use data-driven subscriptions, you must have expertise in building queries and an understanding of how parameters are used. Report server administrators typically create and manage these subscriptions. For more information, please see the following article, Data-Driven Subscriptions: http://msdn.microsoft.com/en-us/library/ms159150(v=sql.90).aspx If you have any question, please feel free to ask. Thanks, Eileen