execute query for each row

I want to execute a query for each row in a report since a parameter in that query relies on a field in the row. Is there a way to do this?I used a subreport to do this.