Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Nested tables

Yanıt Nested tables

  • Thursday, March 07, 2013 8:46 PM
     
     
    Sign In to Vote
    0

    Hi guys,

    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
    •  
     

All Replies

  • Thursday, March 07, 2013 8:58 PM
     
     Answered
    Sign In to Vote
    1

    Hi,

    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).

    Regards

    Srini

     
  • Thursday, March 07, 2013 9:09 PM
     
     
    Sign In to Vote
    0

    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.