Well, that makes sense now now that you put it into perspective. It would be more efficient for SQL to do the front work in filtering the records first...

Great link! Thank you for sharing and it really really helps me put things into context!

I"m still a bit confused which is typically the "Best Practice" to...

Thanks! So I would just create the dataset to include all fields and have the the grouping done in SSRS?