Thanks for sharing with the community... perhaps better suited for a new topic... but here we are...

First a public service warning - with SSRS 2000 and 2005 (and perhaps 2008) using Excel rendering any data region nested inside of a table or matrix data region is not supported. An error is displayed in Excel if this layout is encountered.

Additionally, you should also evaluate the need to use this type of structure versus restructuring information in the report dataset that is used in the table region. I see too many reports where data sets and data regions are needlessly created and combined together versus getting the best design in a single data set and data region.

Ok, off the soapbox....

The key is that if you must have this behavior then workaround the limitation.

The limitation is that you are not able to nest the data region, subreport or other embedded report item (e.g chart) into the detail row of a table data region. The work around involves creating a group on a detail level field in order to have a group header or footer that can successfully permit usage of a data region or subreport. You then can simply remove the no longer needed detail rows (or hide them) and you should arrive at your desired behavior.

Hope this helps and good luck!