>>If I cut and paste the SQL shown into my SQL Management Studio I get a different result. More rows are selected.
More rows are selected in the Query Analyzer than show in the sub report?
If that's the case, are there any selection specifications in the sub report?
What is the data source? Is is the database or a dataset?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.