CODEWITHSUNDEEP
c#asp.netrdlc
user good
user good

Reputation: 107

RDLC group by multiple column in table

I am using rdlc report and using table in it.I want to make following desingn in rdlc but when i drag database column in row group table properties it shows columns on left side.I want Eng Crs Name and Arabic Crs are parent group and Eng Gender and Arb Gender are child group.Where Eng is english and Arb is Arabic.Both are same columns but different language.How can i achieve this following design.

  Eng CrsName        EngGender    Students      ArabicGender     ArbCrs


    engname1           EngM          2            ArabicM        arbn1
                       EngF          3            ArabicF     

   engname2           EngM           4             ArabicM       arbn2
                      EngF           5             ArabicF

Upvotes: 0

Views: 6498

Answers (1)

Oceans
Oceans

Reputation: 3509

The most common way to have parent and children columns is by using the Matrix component. I suggest you give it try on your own first, it should be self explanatory.

If the Matrix does not meet your desires, there is another easy way to group data in an RDLC Report by using the List component.

You can add a table with just the table headers at the top, so it won't be repeated. And then drag the parent (column on which you wish to group) to a TextBox inside the Rectangle of the List. Make sure you group the List on that column. Next you can add a Table with the children data into the rectangle. If there are multiple children, this table will generate multiple rows inside the rectangle. This rectangle will then repeat for every parent item, grouping everything nicely. You can also add lines to represent columns as you see fit.

I hope this helps you a little, if not you should describe your datasource in a bit more detail and I might be able to give a more accurate solution.

Here is a more visual representation of what i tried to explain with words: enter image description here

Upvotes: 1

Related Questions