ReportViewer: Grouping Data in RDLC Report

Submitted by: 
Visitors have accessed this post 39200 times.

In my previous tutorial I discussed on how to create a sub report and pass a parameter value in ReportViewer.

Sub report is useful if you can’t group data to display the related record. This is true with Order-Details report. However, sub reports in RDLC seems too slow when rendering a report. As much as possible, try to avoid using sub report if it can be done using Groupings.

In this VB.NET 2010 project, you’ll see how easy it is to create Groupings to get the same output as my previous tutorial.

All you need in an RDLC report is to create a group, for example an OrderID field. It’s better to create a group using a Key or Primary Key. This is due to the fact that sometimes a “Name” field for example could create duplicate entry but actually two different instances.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Thanks for this source code. I have problem about grouping with Reportviewer and can't find a solution. Many thanks again

Thank you for share


Thanks for the code.

Thank you for sharing

Hi, thanks for sharing, I have a question though, what if the Mozzarella Di Giovanni comes from different vendors, and every vendor has a price and we need to display this info the same way as a third level deeper. How could we do the grouping to handle this so the report would look like this:

10248 Wilman Kala
Qty---Vendor----Product Name--------------Unit Price-------Total
--2---Vendor1---Mozzarella Di Giovanni----30---------------60
--3---Vendor2---Mozzarella Di Giovanni----40---------------120

Thanks sir For Sharing

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe>
  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.