RDLC , Grouping report issue

Hi.
 
I have an issue with RDLC to geneate the below report. I have 3 tables. and I want to display the report like the below (group by VendorID). How to do this. Please help me on this. Thanks
 
tblCompany
tblVendor
tblOrders
 

 
ebinroy
ebinroy
 
0 Points
 
4 Posts
RDLC Report Grouping issue
 
1 hour, 38 minutes ago|LINK
 
Hi.
 
I have an issue with RDLC to geneate the below report. I have 3 tables. and I want to display the report like the below (group by VendorID,OrderNumber). How to do this. Please help me on this. Thanks
 
tblCompany
tblVendor
tblOrders
 

*           [comapany Name]
*           [Comp. Address]
===================================================================
 
[Vendor Name]                                   [Order Number]
[Vendor Address]                [Order Date]
 
--------|---------------|---------------|----------|------------------
ITEM    |   UNIT        |   QUANTITY    |   PRICE  |
--------|---------------|---------------|----------|-------------------
Abc1    |   20.50       |   4           |   82.00  |
Abc2    |   10.20       |   5           |   51.00  |
--------|---------------|---------------|----------|-------------------
        |               |       TOTAL   |   132.00 |
--------|---------------|---------------|----------|-------------------