Yes you are right. But the hard coded value is stored on the report server. Users do not see that bit. Also in this case ( I could be wrong) U might need to turn on Impersonation. Let me know if U get it working.

cheers

anupam