Jyoti Jodha

Jyoti Jodha

  • NA
  • 1.7k
  • 396.8k

how to Show Product name in RDLC Reports in windows c#

Jun 28 2017 2:42 AM
SELECT ID, Billno, Name, Date, Shipped_Details, Order_Number, Sno, pi.Name as Product_Name, Description, Hsn_Code, Qty, Unit, Rate, Amount, Discount, Taxable_Amount,
CGST_Rate, CGST_Amt, SGST_Rate, SGST_Amt, IGST_Rate, IGST_Amt, totalgst, Addcost, Sub_Total, Sub_Discount, Total_Amount, Company_ID
FROM MainBillForm pd LEFT OUTER JOIN
Product AS pi ON pd.Name = pi.Product_ID
WHERE (Billno = @billno) AND (Sno <> 0) AND (Company_ID = @cid)
 
 
AND Product Name Show form Product Table.....

Answers (5)