Hi, I am new to SSRS report.Suppose i have a report which takes a parameter as a dropdown list. Now what i want is when we have admin access,the report should show all the results in the drop downlist and the admin is able to select All or a particular data. Else When we have a particular user we are passing an ID in the query string. How can we access that query string in our report???? Pls helpThanks and regards, Rishabh

Test for the current user or group within a stored procedure on the database server. Populate the resultset of the dropdown list based on current user. This method assumes that the user or group has a login on the database server and that the datasource for the report is using Windows authentication for the current report user (and not a generic service account).

Hi Rishabh Kumar, Besides Stephen Strong’s reply, you could also create a parameter, then retrieve a dynamical dataset based on the parameter value you selected, of course you could add a filter to the dataset or report data region to filter the relevant records you need based on different users. Thanks, Challen Fu