RDLC grouping rows

rdlc dynamic-rdlc-generation
Luis Rosales picture Luis Rosales · Feb 8, 2016 · Viewed 10.3k times · Source

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

                   comment

enter image description here

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?

Answer

Oceans picture Oceans · Feb 8, 2016

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)

Related questions

Dynamically binding of Dataset to RDLC Reports

I would like to bind the dynamically dataset to the rdlc. I can view the report if I use inline DataSource in ASPX file (static binding). However, if I use the following codes, the Report viewer keeps showing "Loading.." Image. …

Read More
How to page break after specific row(Suppose 25 rows) in rdlc reporting

How to page break after Specific rows (like 15 rows) in rdlc reporting.

Read More
How to set parameter values in RDLC

I have added two text boxes for the date range in the report. To fill the values in the text boxes, I set parameters to the text boxes. Now the date range is coming from a form named DateRange having …

Read More