Barbara -- Just out of curiosity, do you have permissions to create a stored proc or function on SQL server from where the data is being sourced? If not, then it changes how I might approach the problem by writing the sql completely in the SSRS rdl.

--pete