Thursday, March 07, 2013 8:46 PM
I am writing a report and wish to have the parent group print a summary on one row, then expand that group to show details of that group (only with different column headers. Basically, I want to stick the smaller table below, into the empty cell of the larger table.
I am obviously not a SSRS guru, so any help would be appreciated, or a suggested alternate tact to use. I have been looking at MSDN and the way I have read it is that a nested data region would be superior to a subreport. But admittedly I don't fully understand that either.
Thanks in advance!EDIT: I should also add, Both tablix are using the same data source table
- Edited by SnakeRider Thursday, March 07, 2013 8:51 PM
Thursday, March 07, 2013 8:58 PM
You did it alraedy, cut the second tablix paste it in the empty cell. Nested tables source is always the parent table source (you can not change it).
Thursday, March 07, 2013 9:09 PM
Thanks for that Srini,
I have just realized that it was not working because I put it in the details row and not the footer *facepalm*.
All is well that ends well.