Generate RDLC Report from Multiple Tables in ASP.Net

Question

I have Customer TableProdut TableOrder TableOrderDetail TableHow i get All join data in RDLC Report any one can help me

dharmendr · Accepted Answer

Hi vailHere I am making use of Microsoftrsquos Northwind Database You can download it from hereDownload and install Northwind DatabaseSQLSELECT odOrderIDcCustomerIDcContactNameprProductNameodUnitPriceodQuantityodDiscount FROM Order Details odINNER JOIN Products pr ON prProductID  odProductIDINNER JOIN Orders o ON oOrderID  odOrderIDINNER JOIN Customers c ON cCustomerID  oCustomerIDORDER BY odOrderID

dharmendr · Answer

Hi vailFirst 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 stepCreate RDLC Report using Stored Procedure in ASPNet with C and VBNet

Generate RDLC Report from Multiple Tables in ASP.Net

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

Company

Explore

Follow us

Contact Us