Take the 2-minute tour ×  I have a bunch of records (orders)
that I want to make available to users to make reports from.
The users come from different departments, and I would like to
make it, so each department can only see their own stuff.  I
can't figure out how to do this the right way.  What I have now
is: - A model where I have placed a Filter on the Order table.
The filter can use GetUserID() to get the users name, but I
can't figure out how I get from that to the "UserDepartment"
table that maps users to specific departments.  Ofcourse, I
would prefer a solution whereby I didn't have to create new
access groups or edit the model for each department that someone
might dream up.  Any clues?  (Using SQL server 2008)  EDIT: This
link http://blogs.msdn.com/bobmeyers/articles/Implementing%5FDat
a%5FSecurity%5Fin%5Fa%5FReport%5FModel.aspx shows the basics of
what I'm trying to do, but the author seems to assume that each
record have a UserName field that can be matched.  In my case i
want all users of depa