I was wondering if when you click on the + in a drill down report, does the report requery the database, or is the report just re-rendered without having to query again?
depending on the answer, performance considerations would be different.
The only requery is on the ReportServer db which has cached the results of the dataset. Your original query is not rerun.