Generate RDLC Report from Multiple Tables in ASP.Net

Last Reply on Aug 17, 2016 05:39 AM By dharmendr

Posted on Aug 16, 2016 09:23 AM

I have 

Customer Table

Produt Table

Order Table

OrderDetail Table

How i get All join data in RDLC Report any one can help me

Posted on Aug 16, 2016 10:08 AM

Hi vail,

Here I am making use of Microsoft’s Northwind Database. You can download it from here.
SQL
SELECT od.OrderID,c.CustomerID,c.ContactName,pr.ProductName,od.UnitPrice,od.Quantity,od.Discount 
FROM [Order Details] od
INNER JOIN Products pr ON pr.ProductID = od.ProductID
INNER JOIN Orders o ON o.OrderID = od.OrderID
INNER JOIN Customers c ON c.CustomerID = o.CustomerID
ORDER BY od.OrderID

 


Posted on Aug 17, 2016 05:39 AM

Hi vail,

First you need to add the dataset to your project then add datatable with the fields you want to display. Refer the below article step by step.

Create RDLC Report using Stored Procedure in ASP.Net with C# and VB.Net