Unfortunately, that's one of the first things I tried.

Here's the thing though (and this is the reason I added the [edit]), refreshing the fields for a Report dataset (that doesn't...

Ah, turns out that I was trying to create a report with "stepped" layout.

Here's a good overview of the process, if anyone ever needs to know:

http://sqldusty.wordpress.com/2011/07/23/creating-stepped-reports-with-ssrs-2008/

Thanks to all who helped!

Hmmm, I've tried that before and what I end up with is:

Is there some hidden step to adding Dealer as a Child Row Group that will move it underneath the...

Thanks for the reply.

I should have known there would be an indent property for the text, that will come in handy.

I'm not sure the snip of the Excel report was...

Yes, it is possible, in fact, it's mostly working on this Excel export, as I explained above, it's just the 1st data point at the Org level ("Direct") uncollapses automatically...