Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication). Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records? Please let me know your suggestion...

Does anyone have idea about this?

Hi Gaurav, In my opinion, you should follow "create a separate table and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table" to statify this requirement. This is the common method for such requirement. thanks, Jerry

Hi Jerry...thanks for the reply. This makes sense