Skip to main content

ReportViewer: Grouping Data in RDLC Report

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 SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

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.

Comments

Submitted byl3oatsu (not verified)on Mon, 02/13/2012 - 17:24

Thanks for this source code. I have problem about grouping with Reportviewer and can't find a solution. Many thanks again
Submitted byAnonymous (not verified)on Sun, 08/26/2012 - 23:26

Good
Submitted by cPubis (not verified)on Wed, 11/13/2013 - 21:08

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 5--------------------------------------------------------------- --2---Vendor1---Mozzarella Di Giovanni----30---------------60 --3---Vendor2---Mozzarella Di Giovanni----40---------------120 ----------------------------------------------------Total--180

Add new comment