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...
View Complete Post