Hey all..
I am woring on this issue..
I have created a RDLC report were everything is works fine .. below is the screen shot...
http://prntscr.com/1qmwqr
you can see i have done Grouping on "RMType" and "LotNo"... my datasource looks like below
(if you cant see the above image then -> http://prntscr.com/1qmwyg)
Now what client needs is... the report should display as follows...
Lot 1 Active
Lot 1 Excipients
.
.
.
Lot 2 Active
Lot 2 Excipients
Lot 1 Lubricant
Lot 2 Lubricant
Lot 1 Coating
Lot 2 ...
Go to the complete details ...