The easiest option is to create a parameter in the report that you reference in the WHERE clause, and pass this parameter when rendering the report.
For example, if the report were to run on the account entity, the SQL query would look like this:
select * from filteredaccount where accountid = @accountid
And the parameter you pass would have ParameterName = accountid
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk