sharepoint - SSRS - filter parameter's Available Values by value of another parameter -

another ssrs question. i've got report want let end-user filter report list of names, names need filtered worksite user at. filtering of values list name parameter needs happen behind scenes; user shouldn't able see or select names not relevant site. example, there 200 unique names in table, 15 of work @ site; end user should able see , select 15 names filter report by. there way filtering of parameter's available values based on value of different parameter (i.e., site)?

nb: report querying sharepoint list, resolution using sql - here or here - not going work; i'm open correction on point, though.

from ssrs side of things, this. (i know little sharepoint)

1. create text report parameter (@user in example) , set default value built-in field "userid". userid "domain\user".
2. create dataset (siteid in example) using @user parameter pull current report runners site id. had create lookup table in sql this.
3. create report parameter of whatever type needed siteid (@site in example), , set default value "get values query". select siteid dataset field default.
4. create dataset (names in example) using @siteid parameter in clause.
5. set both parameters "hidden".

this should allow report auto-execute , retrieve name values match current users' siteid.