reporting services - Report Builder 2.0: Display certain rows based on certain conditions -

i have table has, apart others, 2 columns named partition_name , xkey. want is, when user logs in system, has xkey found in xkey column, display rows "linked" xkey (the rows have xkey). moreover, have check partition_name column. if user logs in, , corespondend of xkey in partition_name ep, have display rows, not related xkey.

i've done first part (display rows based on xkeys) can`t figure out how display rows if partition_name of xkey ep.

this how in rb 3.0; don't know how 2.0 different, may work.

• i don't know how system set up, we'll assume there's way determine user , user's partition_name is. need set hidden parameter set value of user's partition_name; we'll call parameter pn_param; need set hidden filter, we'll call xkey_param.
• set filter on dataset. set value [xkey] or whatever name of column is. make sure type text.
• set operator =
• set expression following:
  =iif(parameters!pn_param.value = "ep", "*", parameters!xkey_param.value)

give try.