Problem in showing tree like report in rdlc for a specific view

[shirajulmamun]

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), AccountSubTypeN ame 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

[Rabbit]

Group on those fields.

[shirajulmamun]

Rabbit, Thanks for your reply, I tried a lot grouping those fields but I could not resolved the output format as I wanted(as shown in my pic). I want to clear my position,

I want to show multi-level data in rdlc report, as you can see from the posting figure, <Master Type Name> can have many child <Account Type> and <Account Type> can have children, so you can see its a 4 level data representation.

I dont want to represent them in many columns, I just want them to show in a single column, and padding for every child thus I can identify their parent child relationship, also every child has some value which will be shown in another parallel column (as shown in pic)

Can you please tell me, what the grouping procedure, thus I can show my report as same as the format I wanted, if it is needed custom code I will try to do that, if this hierarchy is manageable by c# code please just hint me, give me any link if u know.

Thanks for your reply.

[Rabbit]

You mean you want to use just one column to represent data from multiple columns? You can't do that.

[shirajulmamun]

Hi Rabbit, i have done it, Hierarchical representation of multiple column values in a single column in rdlc as I wanted described in this post, I will describe it later in another post and will leave a link here.