Hello, we got a lot of people which are using our reports. Based on the user we want to offer them different report parameter values. For example an employee should just see all countries of Europe another one should just see the countrys of Asia and so on. Is the Report Manager able to create such permissions? Or is there any third party addon available? Please don't post solutions like creating a table and saving the permissions in there by manually editing them, and then filter the parameter values based on that table. We got the SSRS 2005 right now, but we will upgrade to 2008 R2 in some weeks.

Hi, For this, 1. There should be information per User that this user belongs to which geography area 2. You need to create parameter with (get values from query) 3. Need to create one Stored procedure called: GetCountries @UserID, where @userId will be passed (login userid) 4. This Stored Procedure, created in #3 will returns only countries that needs to be displayed for that user. e.g for user from EUROPE only Europian countries will be listed, so user has to select values from those options only Thanks,Tejas Shah SQL YOGA

This is one part of the solution. But I also need to create the table mentioned in #1 of your answer. Is there a special menu in / addon for the SQL Report Manager which helps me to create that information?

Hi, #1 will be application specific and needs to be designed as per your needs. You need to map each user with location on which you can create a Stored procedure as mentioned in #3 Thanks,Tejas Shah SQL YOGA