How to add row group underneath of the Column Group

I am creating a Horizontal Balance Sheet Report in RDLC. I have One dataset which consists of fields as follows : Ac_Sch_Type,Ac_Sch_Name,Ac_Group_Name,

Main_Account,Sub_Account,Amount,Note_No.

Ac_Sch_Type consists of two values Assets and Liabilities.

So my desired result is:

Main_Account | | xxx | Main_Account | | xxx

Sub_Account | | xxx | Sub_Account | | xxx

But my Output is coming like this:

Ac_Sch_Name | | | | |

Ac_Group_Name | x | xxxx | | x |

Main_Account | | xxx | | |

Sub_Account | | xxx | | |

| | | Main_Account | | xxx

| | | Sub_Account | | xx

Ac_Sch_Name,Ac_Group_Name,Main_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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
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.
0