OK, I'm frustrated.  If I take to long to write my reply it disspaears when I hit preview....

Let me try this again.

Your exactly right with the second option - I'm trying to limit hte selction to only what is valid based on the logged in user.

I am trying to dynamic SQL but am still having a few issues.  If I try to use User!UserID direclty in the query I get an error:

If I try to assign it to a query parameter that is mapped to a report paramter I get another error.

I have actually managed to crash visual studio now with one thing I was trying and am having difficulty getting my proejct back up. 

Please anymore advice is greatly appreciated.