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.
| Author |
Topic |
|
yogeshprabhu
Starting Member
1 Post |
 Posted - 2004-11-20 : 23:40:16
|
| In the solution I'm trying to develop I have to create a parameter list that could vary based on user login. Different users can be assigned to different regions, and I have to display list of available regions for the logged in user. I tried to create a dynamic query as a VB.NET Shared Function and referred it in the DataSet for this query parameter, but the parameter appears grayed out in the Preview tab. |
|
|
johnb
Starting Member
8 Posts |
Posted - 2004-11-24 : 11:45:08
|
One solution would be to create a table with the different users and the regions that they assigned to eg.RS_USER, REGIONBarry, NorthDwaine, West etcThen create a dataset with this table and put a filter on the dataset for the user:RS_USER = USER!User_IDIf you then use this dataset in the parameter all should be grand!Hope this helpsJohn. quote:
Originally posted by yogeshprabhu
In the solution I'm trying to develop I have to create a parameter list that could vary based on user login. Different users can be assigned to different regions, and I have to display list of available regions for the logged in user. I tried to create a dynamic query as a VB.NET Shared Function and referred it in the DataSet for this query parameter, but the parameter appears grayed out in the Preview tab.
|
 |
|
|
|
|
|
How to create user based parameter list?