Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Change parameters according do user

Author  Topic  epawelek Starting Member 1 Post Posted - 2009-05-27 : 04:20:49 Hi, I have report with parameter City, which is generated from query Select Name, ID from tblCity and now a need to do some thing like this. Show in parameter dropdown list only selected cities according to logged user. Is ther any way to do this? I was thinking to use custom code method with Report userID as parameter, but i have no idea how set result of this method as this paramenter.