My best example would be a Client which has multiple Contacts and also multiple Products. The parent would show Client X's name and all the Contacts for Client X. Then beneath that would be all the Products for Client X. After that would be the next client...Client Y, and so on...
I too have been looking for an example of this functionality and have not seen anything, anywhere on the internet. There seems to be a huge lack of examples and good documentation for anything related to SSRS. Books only show the basics and msdn2 is crap for learning.
Subreports cannot be exported to EXCEL so subreports will not help me. It shouldn't be that hard to link datasets on a key value for this type of functionality. I have not been convinced that this is not possible.
If anyone can solve this, please post!