Create Nested Tablix in SSRS Report

Here if we need some output like Hierarchical (parent-child) i.e. Country and their respective States. We just need to Add Tablix inside Tablix row. Here are the steps how we can do that...
·         Create your Dataset According to your output.
·         Apply your Dataset in Tablix with parent Group (Country Wise)
·         Create another Tablix and apply the same dataset with Subgroup (State Wise)
·         Go to the first Tablix add the row inside the group and merge the columns and right click the row and go to visibility and set it to hide and toggle Item to be set as Country Group
·         Copy the second Tablix and paste it into the merged row

·         Now run the preview and see the output.

Comments