am facing problem with reporting services in rdlc, I want to represent a hierarchy representation of data which is received from my Balancesheet View as shown bellow - View definition
I want to show the output report as bellow format - Output format of report according to view as you can see from the image, the MastertypeName is the parent of AccountTypeName(one or more), AccountSubTypeName is child of AccountType .... for every child there is a amount field(Posted Amount) and the sub-total of the childrens, ultimately the total of the sub-totals will be shown in the bellow part of the report.
I am new to reporting services, I have searched many websites for this specific problem but could not find solution regarding this issue.
It will be a great help if you please help me to solve this problem with solution in the comment or giving link, Its an urgent issue for my department to solve this to give our product to the client.
Thanks in advance