RDLC grouping rows

Question

I'm trying to do a rdlc table/matrix gruoping by Id. I have a DataSet which is returning:

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

                   comment

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?

score 4 · Accepted Answer · answered Feb 08 '16 at 15:16

4

This can easily be achieved by using RowGroups. For your example you'd want a stepped report.

Here is an excellent tutorial from MSDN that should be of use to you: Create a Stepped Report (Report Builder and SSRS)

answered Feb 08 '16 at 15:16

Oceans

Thanks, it helped me a lot! – Luis Rosales Feb 08 '16 at 17:10
Do you know scope expression for the visibility of the textboxes? – Luis Rosales Feb 09 '16 at 14:11
When I have a row duplicated in the exppresion SUM(Fields!SubTotal.Value, "PurchaseOrderDataSet") it took me the values twice – Luis Rosales Feb 09 '16 at 14:13

1 Answers1