Thanks Jeff but no - I see what you're getting at but it doesn't quite do it.

Report Builder can only use tables / views as Model datasources.

guys the main issue here is that the subquery needs to be able to reference the range of dates (not just a single date) of the outer query.

thanks

by passing them to the view as a where clause.

ie select * from vwView where ShipCity = 'Paris' and OrderDate between '01-jan-1997' and '01-jan-2000' .

Yes but unfortunately I can't use variables / stored procs because this view is to be used as a datasource for Reporting Services Report Builder which only allows tables and...