none
Tree structure in reports RRS feed

  • General discussion

  •   I have a datatable with columns Id,Name and ParentId.

     I need to create tree structure in the rdlc report (group by ParentId) with the above said data.

     eg Table

        Id     Name     ParentId

        1       Data1   

        2       Data2        1

        3       Data3        1

        4       Data4        2

    My report should be shown like below

            

    Data1    
      Data2  
        Data4
      Data3  

                    

    Can any guide me on this.

    Thanks

    Karan M

    Thursday, March 21, 2013 2:39 PM

All replies

  • Hello Karan M,

    You can use the Advanced tab in Group properties of your tablix. You must set Recursive parent textbox to your ParentId field and Document map textbox to Name field.

    It won't be a "recursive" tablix but you can navigate in document map section of the report using the tree structure.

    Thursday, March 21, 2013 5:45 PM
  • Hi David

              Thanks for your suggestion but our requirement is we should show that like tree structure with toggle. Can u show me any workaround for this.

    Thanks

    Karan M

    Friday, March 22, 2013 4:52 AM
  • You'll have a tree recursive structure with toggle feature whether you use document map and you'll be able to show current selection on tablix (the document map will be pointing to current clicked item on tree).

    It will be something like this:


    Friday, March 22, 2013 8:29 AM
  • Hi David

             Thanks, Its works fine.

    Regards

    Karan M

    Tuesday, March 26, 2013 5:21 AM