hey i m generating a crystal report in vs 2010 using linq to sql in desktop apps.
alter proc wholesale_print
(
@invoice_no varchar(15),
@cust_id int
)
as
begin
select cust.customer_name,item.item_name,inv.invoice_no,inv.Qty,inv.price,
inv.item_amount,inv.disc,inv.disc_amt,inv.vat,inv.vat_amt,inv.total_amt
from inv_invoice_detail as inv
inner join Inv_Customer_Name as cust
on inv.cust_id=cust.customer_id
inner join Inv_item_master as item
on inv.item_id=item.item_id
where inv.invoice_no=@invoice_no
and inv.cust_id=@cust_id
end
code which i wrote at the click event of print button
Inventory_dataDataContext linq = new Inventory_dataDataContext();
var abc = linq.wholesale_print(txt_invoice.text,Convert.ToInt32(cmb_cust.selectedvalue);
rpt.SetDataSource(abc);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();*/