@pralnico: "Hello,
Is it possible to configure a report so that certain users have the 
possiblity to select all the parameters (administrators) and that the others 
(employed) can selected only part of the parameters?
Thanks for your help
Nico"
    @CharlesKangai: "Do the filtering in the query that returns the picklist of the parameters. In 
other words, filter the parameter list at the data source end. You can pass 
the user's name as a parameter in the query. For example, suppose you use a 
stored procedure called ProcGetParameters to return the parameters of your 
query. Your sproc definition could look something like:
create proc ProcGetParameters (@username nvarchar(40))
as 
if @username not in (select Name from AdminsTable)
  select parametercol from MyTable where ...
else
  select parametercol from MyTable
go
The user's name can be passed to the sproc from the report as it is stored 
in the User!UserID variable.
HTH
Charles Kangai, MCT, MCDBA
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.sqlserver.reportingsvcs.20140716.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}