How to add row group underneath of the Column Group

Question

I am creating a Horizontal Balance Sheet Report in RDLC. I have One dataset which consists of fields as follows : Ac_Sch_TypeAc_Sch_NameAc_Group_Name Main_AccountSub_AccountAmountNote_No. Ac_Sch_Type consists of two values Assets and Liabilities. So my desired result is: Ac_Sch_Type (Liabilities) | Note_No | Amount |Ac_Sch_Type (Assets)| Note_No | Amount Ac_Sch_Name | | | Ac_Sch_Name | | Ac_Group_Name | x | xxxx | Ac_Group_Name | x | xxxx Main_Account | | xxx | Main_Account | | xxx Sub_Account | | xxx | Sub_Account | | xxx But my Output is coming like this: Ac_Sch_Type (Liabilities) | Note_No | Amount | Ac_Sch_Type (Assets)| Note_No | Amount Ac_Sch_Name | | | | | Ac_Group_Name | x | xxxx | | x | Main_Account | | xxx | | | Sub_Account | | xxx | | | | | | Ac_Sch_Name | | | | | Ac_Group_Name | | xxxx | | | Main_Account | | xxx | | | Sub_Account | | xx Ac_Sch_Name Ac_Group_NameMain_Account  Sub_Account are row groups.Data may vary in group but table may look equal at both sides and report should be in single tablix.

Manas Mohapatra · Answer

You have to create drilldown reports. Follow below links: http://ssrstutorials.blogspot.in/2012/10/lesson-16-drilldown-matrix-reports.html http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD#5 or create a list manually to impelement your logic and bind it report.