I'm trying to do a rdlc table/matrix gruoping by Id.
I have a DataSet which is returning:
Id | name | price | quantity | subtotal | comment
The comment column is optional,also it can have multiple comments per Id so it could return duplicate rows but with different comment column.
Then I want to display in a Table or matrix the data like this
Id | name | quantity | price | subtotal
I mean adding additional rows per comment.
Is it possible to display rows in that format?
If so, What is the best way to achieve it?