Loading

ReportViewer: Grouping Data in RDLC Report

Submitted by: 
Visitors have accessed this post 28247 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 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

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

Good

Thanks for the code.

takhei.tinakor's picture

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

Thanks sir For Sharing

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
To prevent automated spam submissions leave this field empty.

Filtered HTML

  • 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.