Grouping issue grouping by 2 fields over 3 or more lines in RDLC Report

Question

I am back with another RDLC issue.

I have a dataset containing these fields

CustomerID, Section, Code, Title, Active

Lets say the data looks like this:

001, Section1, NP234, Title1, True
001, Section1, IMO-100, Title2, False
002, DIGITAL UPDATES, DIG85, Lorem, True

I want to group on CustomerID and Section so that for the above 3 rows the tablix looks like:

Customer 001
Section       Code        Title       Active
Section1     NP234      Title1     True
                  IMO-100   Title2     False
Customer 002
Section      Code         Title       Active
DIGITAL UPDATES     DIG85     Lorem     True

So basically group by CustomerId and Section, however when I try this the tablix seems to have a mind of its own, putting in rows/columns all over the shop.

Any advice is welcome.

Thanks,
Andrew

Andrew · Answer

Thanks for your reply However the data retrieved from database is in the correct format. It is just formatting the report that is the problem. When I group on CustomerID that whole column becomes as one I cannot put Section underneath it so it means for the whole report there is a large blank area under the heading CustomerID All I want is to list group by CustomerID and repeat the headings for each different CustomerID.

Suthish Nair · Answer

My advice is to group the records at DB levelitself and then design RDLC

Grouping issue, grouping by 2 fields over 3 or more lines in RDLC Report