Hi vail,

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

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